ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 122 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 12
county 12
- Cole 32
- Camden 14
- Stone 9
- Franklin 8
- St. Francois 7
- Stoddard 7
- Newton 4
- Lafayette 2
- Clay 1
- Jackson 1
- Kansas City 1
- Washington 1
state 1
- Missouri · 87 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501182 | 2501182 | 2022-05-13 | Stone | Missouri | 29209 | 5829 | 122 |
2497924 | 2497924 | 2022-05-12 | Stone | Missouri | 29209 | 5805 | 122 |
2494666 | 2494666 | 2022-05-11 | Stone | Missouri | 29209 | 5805 | 122 |
2491408 | 2491408 | 2022-05-10 | Stone | Missouri | 29209 | 5805 | 122 |
2488150 | 2488150 | 2022-05-09 | Stone | Missouri | 29209 | 5805 | 122 |
2484893 | 2484893 | 2022-05-08 | Stone | Missouri | 29209 | 5805 | 122 |
2481635 | 2481635 | 2022-05-07 | Stone | Missouri | 29209 | 5805 | 122 |
2478377 | 2478377 | 2022-05-06 | Stone | Missouri | 29209 | 5805 | 122 |
2475119 | 2475119 | 2022-05-05 | Stone | Missouri | 29209 | 5797 | 122 |
2305876 | 2305876 | 2022-03-14 | Stoddard | Missouri | 29207 | 6076 | 122 |
2302625 | 2302625 | 2022-03-13 | Stoddard | Missouri | 29207 | 6076 | 122 |
2299373 | 2299373 | 2022-03-12 | Stoddard | Missouri | 29207 | 6076 | 122 |
2296121 | 2296121 | 2022-03-11 | Stoddard | Missouri | 29207 | 6076 | 122 |
2292869 | 2292869 | 2022-03-10 | Stoddard | Missouri | 29207 | 6077 | 122 |
2289617 | 2289617 | 2022-03-09 | Stoddard | Missouri | 29207 | 6076 | 122 |
2286365 | 2286365 | 2022-03-08 | Stoddard | Missouri | 29207 | 6072 | 122 |
2260297 | 2260297 | 2022-02-28 | Lafayette | Missouri | 29107 | 7703 | 122 |
2247293 | 2247293 | 2022-02-24 | Lafayette | Missouri | 29107 | 7701 | 122 |
2214840 | 2214840 | 2022-02-14 | Washington | Missouri | 29221 | 5860 | 122 |
1827873 | 1827873 | 2021-10-18 | Camden | Missouri | 29029 | 6270 | 122 |
1827933 | 1827933 | 2021-10-18 | Newton | Missouri | 29145 | 7699 | 122 |
1824624 | 1824624 | 2021-10-17 | Camden | Missouri | 29029 | 6270 | 122 |
1824684 | 1824684 | 2021-10-17 | Newton | Missouri | 29145 | 7699 | 122 |
1821375 | 1821375 | 2021-10-16 | Camden | Missouri | 29029 | 6268 | 122 |
1821435 | 1821435 | 2021-10-16 | Newton | Missouri | 29145 | 7698 | 122 |
1818126 | 1818126 | 2021-10-15 | Camden | Missouri | 29029 | 6259 | 122 |
1818186 | 1818186 | 2021-10-15 | Newton | Missouri | 29145 | 7694 | 122 |
1814877 | 1814877 | 2021-10-14 | Camden | Missouri | 29029 | 6247 | 122 |
1811629 | 1811629 | 2021-10-13 | Camden | Missouri | 29029 | 6236 | 122 |
1808380 | 1808380 | 2021-10-12 | Camden | Missouri | 29029 | 6228 | 122 |
1805129 | 1805129 | 2021-10-11 | Camden | Missouri | 29029 | 6226 | 122 |
1801880 | 1801880 | 2021-10-10 | Camden | Missouri | 29029 | 6226 | 122 |
1798631 | 1798631 | 2021-10-09 | Camden | Missouri | 29029 | 6226 | 122 |
1795382 | 1795382 | 2021-10-08 | Camden | Missouri | 29029 | 6218 | 122 |
1792133 | 1792133 | 2021-10-07 | Camden | Missouri | 29029 | 6196 | 122 |
1788884 | 1788884 | 2021-10-06 | Camden | Missouri | 29029 | 6191 | 122 |
1785636 | 1785636 | 2021-10-05 | Camden | Missouri | 29029 | 6170 | 122 |
1668765 | 1668765 | 2021-08-30 | St. Francois | Missouri | 29187 | 10357 | 122 |
1665518 | 1665518 | 2021-08-29 | St. Francois | Missouri | 29187 | 10296 | 122 |
1662270 | 1662270 | 2021-08-28 | St. Francois | Missouri | 29187 | 10258 | 122 |
1659022 | 1659022 | 2021-08-27 | St. Francois | Missouri | 29187 | 10203 | 122 |
1655773 | 1655773 | 2021-08-26 | St. Francois | Missouri | 29187 | 10140 | 122 |
1652526 | 1652526 | 2021-08-25 | St. Francois | Missouri | 29187 | 10097 | 122 |
1649278 | 1649278 | 2021-08-24 | St. Francois | Missouri | 29187 | 10052 | 122 |
1282312 | 1282312 | 2021-05-03 | Cole | Missouri | 29051 | 9070 | 122 |
1279065 | 1279065 | 2021-05-02 | Cole | Missouri | 29051 | 9066 | 122 |
1275818 | 1275818 | 2021-05-01 | Cole | Missouri | 29051 | 9062 | 122 |
1272571 | 1272571 | 2021-04-30 | Cole | Missouri | 29051 | 9060 | 122 |
1269324 | 1269324 | 2021-04-29 | Cole | Missouri | 29051 | 9056 | 122 |
1266077 | 1266077 | 2021-04-28 | Cole | Missouri | 29051 | 9047 | 122 |
1262830 | 1262830 | 2021-04-27 | Cole | Missouri | 29051 | 9039 | 122 |
1259583 | 1259583 | 2021-04-26 | Cole | Missouri | 29051 | 9036 | 122 |
1256336 | 1256336 | 2021-04-25 | Cole | Missouri | 29051 | 9034 | 122 |
1253089 | 1253089 | 2021-04-24 | Cole | Missouri | 29051 | 9031 | 122 |
1249842 | 1249842 | 2021-04-23 | Cole | Missouri | 29051 | 9027 | 122 |
1246595 | 1246595 | 2021-04-22 | Cole | Missouri | 29051 | 9023 | 122 |
1243348 | 1243348 | 2021-04-21 | Cole | Missouri | 29051 | 9014 | 122 |
1240101 | 1240101 | 2021-04-20 | Cole | Missouri | 29051 | 9014 | 122 |
1236854 | 1236854 | 2021-04-19 | Cole | Missouri | 29051 | 9012 | 122 |
1233607 | 1233607 | 2021-04-18 | Cole | Missouri | 29051 | 9012 | 122 |
1230359 | 1230359 | 2021-04-17 | Cole | Missouri | 29051 | 9004 | 122 |
1227111 | 1227111 | 2021-04-16 | Cole | Missouri | 29051 | 9111 | 122 |
1223863 | 1223863 | 2021-04-15 | Cole | Missouri | 29051 | 9104 | 122 |
1220616 | 1220616 | 2021-04-14 | Cole | Missouri | 29051 | 9101 | 122 |
1217368 | 1217368 | 2021-04-13 | Cole | Missouri | 29051 | 9091 | 122 |
1214121 | 1214121 | 2021-04-12 | Cole | Missouri | 29051 | 9086 | 122 |
1210873 | 1210873 | 2021-04-11 | Cole | Missouri | 29051 | 9084 | 122 |
1207624 | 1207624 | 2021-04-10 | Cole | Missouri | 29051 | 9082 | 122 |
1204376 | 1204376 | 2021-04-09 | Cole | Missouri | 29051 | 9079 | 122 |
1201128 | 1201128 | 2021-04-08 | Cole | Missouri | 29051 | 9075 | 122 |
1197879 | 1197879 | 2021-04-07 | Cole | Missouri | 29051 | 9068 | 122 |
1194630 | 1194630 | 2021-04-06 | Cole | Missouri | 29051 | 9061 | 122 |
1191381 | 1191381 | 2021-04-05 | Cole | Missouri | 29051 | 9062 | 122 |
1188133 | 1188133 | 2021-04-04 | Cole | Missouri | 29051 | 9059 | 122 |
1184886 | 1184886 | 2021-04-03 | Cole | Missouri | 29051 | 9057 | 122 |
1181640 | 1181640 | 2021-04-02 | Cole | Missouri | 29051 | 9047 | 122 |
967391 | 967391 | 2021-01-26 | Clay | Missouri | 29047 | 8613 | 122 |
944685 | 944685 | 2021-01-19 | Franklin | Missouri | 29071 | 7664 | 122 |
941440 | 941440 | 2021-01-18 | Franklin | Missouri | 29071 | 7623 | 122 |
938195 | 938195 | 2021-01-17 | Franklin | Missouri | 29071 | 7582 | 122 |
934950 | 934950 | 2021-01-16 | Franklin | Missouri | 29071 | 7560 | 122 |
931705 | 931705 | 2021-01-15 | Franklin | Missouri | 29071 | 7508 | 122 |
928460 | 928460 | 2021-01-14 | Franklin | Missouri | 29071 | 7463 | 122 |
925214 | 925214 | 2021-01-13 | Franklin | Missouri | 29071 | 7381 | 122 |
921969 | 921969 | 2021-01-12 | Franklin | Missouri | 29071 | 7339 | 122 |
662391 | 662391 | 2020-10-24 | Jackson | Missouri | 29095 | 9765 | 122 |
561867 | 561867 | 2020-09-23 | Kansas City | Missouri | 11072 | 122 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);