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 came close together and others decades apart.
No coding needed. Start in a spreadsheet or use paper timeline cards.
10 amendments.
73 years.
1919 – 1992
Why were two of these ratified in 1933, and why did amendment 27 come more than 20 years after amendment 26?
The free sample contains amendments 18–27 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. Mark records that fall in the same year. With the complete file, add amendments 1–17, including the ten ratified together on December 15, 1791.
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 most recent amendments. The Data Pass adds the rest, including the ten ratified together in 1791, so your class can explore the full timeline.
The Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the whole catalog.
Data Pass
$69one payment / 365 days
Get the Data PassYour key arrives by email. No account to create and no automatic renewal.
Use it in your own projects, coursework, research, or products you sell; commercial use is allowed, free or paid. Check the dataset’s scope and sources before buying; the Data Pass is non-refundable under our terms.