History meets spreadsheet skills
Turn dates
into a timeline.
Turn amendment numbers and ratification dates into a timeline. Start with a small, readable file, then explore why some amendments share a ratification date.
No coding needed. Start in a spreadsheet or use paper timeline cards.
Ten amendments.
One ratification date.
December 15, 1791
Why do the first ten records share a date?
The free sample contains amendments 1–10 and their ratification dates. Use the source links to investigate the history behind the pattern.
A ready-to-adapt lesson
From a table
to a timeline.
The U.S. Constitutional Amendments and Ratification Dates dataset has two columns for this activity: AmendmentNumber and RatificationDate.
The file provides dates, not amendment text or an explanation of their legal meaning. Pair it with historical documents and reading appropriate to your class.
Read the sample together.
Identify what each row represents. Ask students to distinguish the amendment number from its date. Format the date column as a date if the spreadsheet displays a time too.
Build and label the timeline.
Place each record by its ratification date, using amendment numbers as labels. Stack records that share a date. With the complete file, extend the exercise beyond the first ten amendments.
Investigate a pattern.
Choose a group of amendments with nearby dates, or a long gap between dates, then consult the dataset’s linked sources. Have students separate observations they can make from the table from explanations that require historical evidence.
Questions to discuss with your class
- What does this timeline tell us, and what does it leave out?
- How does a shared date change the way we draw or label a timeline?
- With the complete file, where are the longest gaps between ratification dates?
- Why should a chart distinguish a proposal date from a ratification date?
For younger learners, use labeled cards. For older students, calculate the time between different ratification dates and write a short explanation with source references.
When you need the whole list
Get the complete
datasets.
The sample covers the first ten amendments. A pass adds the remaining records so your class can explore the full timeline held in the dataset.
A Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the available catalog.
Data Pass
$39one payment / 365 days
Choose your passYour key arrives by email. No account to create and no automatic renewal.
For your own projects, coursework, teaching, research, and internal work. If you incorporate data into a product or service you provide to others, choose a Commercial Pass. Check the dataset’s scope and sources before buying; passes are non-refundable under our terms.