ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,026 rows where county = "Clinton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Clinton · 3,642 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278157 | 1278157 | 2021-05-02 | Clinton | Illinois | 17027 | 5737 | 99 |
1278258 | 1278258 | 2021-05-02 | Clinton | Indiana | 18023 | 4258 | 58 |
1278361 | 1278361 | 2021-05-02 | Clinton | Iowa | 19045 | 5489 | 92 |
1278570 | 1278570 | 2021-05-02 | Clinton | Kentucky | 21053 | 1448 | 32 |
1278804 | 1278804 | 2021-05-02 | Clinton | Michigan | 26037 | 7286 | 82 |
1279064 | 1279064 | 2021-05-02 | Clinton | Missouri | 29049 | 1951 | 65 |
1279398 | 1279398 | 2021-05-02 | Clinton | New York | 36019 | 4701 | 33 |
1279617 | 1279617 | 2021-05-02 | Clinton | Ohio | 39027 | 3693 | 61 |
1279824 | 1279824 | 2021-05-02 | Clinton | Pennsylvania | 42035 | 3554 | 62 |
1274910 | 1274910 | 2021-05-01 | Clinton | Illinois | 17027 | 5735 | 99 |
1275011 | 1275011 | 2021-05-01 | Clinton | Indiana | 18023 | 4257 | 58 |
1275114 | 1275114 | 2021-05-01 | Clinton | Iowa | 19045 | 5483 | 92 |
1275323 | 1275323 | 2021-05-01 | Clinton | Kentucky | 21053 | 1448 | 32 |
1275557 | 1275557 | 2021-05-01 | Clinton | Michigan | 26037 | 7286 | 82 |
1275817 | 1275817 | 2021-05-01 | Clinton | Missouri | 29049 | 1950 | 65 |
1276151 | 1276151 | 2021-05-01 | Clinton | New York | 36019 | 4693 | 33 |
1276370 | 1276370 | 2021-05-01 | Clinton | Ohio | 39027 | 3689 | 61 |
1276577 | 1276577 | 2021-05-01 | Clinton | Pennsylvania | 42035 | 3544 | 62 |
1271663 | 1271663 | 2021-04-30 | Clinton | Illinois | 17027 | 5732 | 99 |
1271764 | 1271764 | 2021-04-30 | Clinton | Indiana | 18023 | 4253 | 58 |
1271867 | 1271867 | 2021-04-30 | Clinton | Iowa | 19045 | 5477 | 92 |
1272076 | 1272076 | 2021-04-30 | Clinton | Kentucky | 21053 | 1448 | 32 |
1272310 | 1272310 | 2021-04-30 | Clinton | Michigan | 26037 | 7271 | 81 |
1272570 | 1272570 | 2021-04-30 | Clinton | Missouri | 29049 | 1948 | 65 |
1272904 | 1272904 | 2021-04-30 | Clinton | New York | 36019 | 4683 | 33 |
1273123 | 1273123 | 2021-04-30 | Clinton | Ohio | 39027 | 3687 | 61 |
1273330 | 1273330 | 2021-04-30 | Clinton | Pennsylvania | 42035 | 3537 | 62 |
1268416 | 1268416 | 2021-04-29 | Clinton | Illinois | 17027 | 5731 | 99 |
1268517 | 1268517 | 2021-04-29 | Clinton | Indiana | 18023 | 4248 | 58 |
1268620 | 1268620 | 2021-04-29 | Clinton | Iowa | 19045 | 5470 | 92 |
1268829 | 1268829 | 2021-04-29 | Clinton | Kentucky | 21053 | 1448 | 32 |
1269063 | 1269063 | 2021-04-29 | Clinton | Michigan | 26037 | 7250 | 81 |
1269323 | 1269323 | 2021-04-29 | Clinton | Missouri | 29049 | 1945 | 65 |
1269657 | 1269657 | 2021-04-29 | Clinton | New York | 36019 | 4675 | 33 |
1269876 | 1269876 | 2021-04-29 | Clinton | Ohio | 39027 | 3682 | 60 |
1270083 | 1270083 | 2021-04-29 | Clinton | Pennsylvania | 42035 | 3525 | 62 |
1265169 | 1265169 | 2021-04-28 | Clinton | Illinois | 17027 | 5732 | 99 |
1265270 | 1265270 | 2021-04-28 | Clinton | Indiana | 18023 | 4241 | 58 |
1265373 | 1265373 | 2021-04-28 | Clinton | Iowa | 19045 | 5461 | 92 |
1265582 | 1265582 | 2021-04-28 | Clinton | Kentucky | 21053 | 1448 | 32 |
1265816 | 1265816 | 2021-04-28 | Clinton | Michigan | 26037 | 7235 | 81 |
1266076 | 1266076 | 2021-04-28 | Clinton | Missouri | 29049 | 1944 | 65 |
1266410 | 1266410 | 2021-04-28 | Clinton | New York | 36019 | 4666 | 33 |
1266629 | 1266629 | 2021-04-28 | Clinton | Ohio | 39027 | 3676 | 60 |
1266836 | 1266836 | 2021-04-28 | Clinton | Pennsylvania | 42035 | 3508 | 62 |
1261922 | 1261922 | 2021-04-27 | Clinton | Illinois | 17027 | 5726 | 99 |
1262023 | 1262023 | 2021-04-27 | Clinton | Indiana | 18023 | 4238 | 58 |
1262126 | 1262126 | 2021-04-27 | Clinton | Iowa | 19045 | 5451 | 92 |
1262335 | 1262335 | 2021-04-27 | Clinton | Kentucky | 21053 | 1448 | 32 |
1262569 | 1262569 | 2021-04-27 | Clinton | Michigan | 26037 | 7209 | 81 |
1262829 | 1262829 | 2021-04-27 | Clinton | Missouri | 29049 | 1943 | 65 |
1263163 | 1263163 | 2021-04-27 | Clinton | New York | 36019 | 4662 | 33 |
1263382 | 1263382 | 2021-04-27 | Clinton | Ohio | 39027 | 3654 | 60 |
1263589 | 1263589 | 2021-04-27 | Clinton | Pennsylvania | 42035 | 3496 | 61 |
1258675 | 1258675 | 2021-04-26 | Clinton | Illinois | 17027 | 5726 | 99 |
1258776 | 1258776 | 2021-04-26 | Clinton | Indiana | 18023 | 4235 | 58 |
1258879 | 1258879 | 2021-04-26 | Clinton | Iowa | 19045 | 5438 | 92 |
1259088 | 1259088 | 2021-04-26 | Clinton | Kentucky | 21053 | 1448 | 32 |
1259322 | 1259322 | 2021-04-26 | Clinton | Michigan | 26037 | 7188 | 80 |
1259582 | 1259582 | 2021-04-26 | Clinton | Missouri | 29049 | 1942 | 65 |
1259916 | 1259916 | 2021-04-26 | Clinton | New York | 36019 | 4654 | 33 |
1260135 | 1260135 | 2021-04-26 | Clinton | Ohio | 39027 | 3652 | 60 |
1260342 | 1260342 | 2021-04-26 | Clinton | Pennsylvania | 42035 | 3482 | 61 |
1255428 | 1255428 | 2021-04-25 | Clinton | Illinois | 17027 | 5722 | 99 |
1255529 | 1255529 | 2021-04-25 | Clinton | Indiana | 18023 | 4232 | 58 |
1255632 | 1255632 | 2021-04-25 | Clinton | Iowa | 19045 | 5429 | 92 |
1255841 | 1255841 | 2021-04-25 | Clinton | Kentucky | 21053 | 1448 | 32 |
1256075 | 1256075 | 2021-04-25 | Clinton | Michigan | 26037 | 7131 | 80 |
1256335 | 1256335 | 2021-04-25 | Clinton | Missouri | 29049 | 1942 | 65 |
1256669 | 1256669 | 2021-04-25 | Clinton | New York | 36019 | 4642 | 33 |
1256888 | 1256888 | 2021-04-25 | Clinton | Ohio | 39027 | 3650 | 60 |
1257095 | 1257095 | 2021-04-25 | Clinton | Pennsylvania | 42035 | 3481 | 61 |
1252181 | 1252181 | 2021-04-24 | Clinton | Illinois | 17027 | 5721 | 99 |
1252282 | 1252282 | 2021-04-24 | Clinton | Indiana | 18023 | 4231 | 58 |
1252385 | 1252385 | 2021-04-24 | Clinton | Iowa | 19045 | 5427 | 92 |
1252594 | 1252594 | 2021-04-24 | Clinton | Kentucky | 21053 | 1448 | 32 |
1252828 | 1252828 | 2021-04-24 | Clinton | Michigan | 26037 | 7131 | 80 |
1253088 | 1253088 | 2021-04-24 | Clinton | Missouri | 29049 | 1941 | 65 |
1253422 | 1253422 | 2021-04-24 | Clinton | New York | 36019 | 4633 | 33 |
1253641 | 1253641 | 2021-04-24 | Clinton | Ohio | 39027 | 3649 | 60 |
1253848 | 1253848 | 2021-04-24 | Clinton | Pennsylvania | 42035 | 3472 | 61 |
1248934 | 1248934 | 2021-04-23 | Clinton | Illinois | 17027 | 5721 | 99 |
1249035 | 1249035 | 2021-04-23 | Clinton | Indiana | 18023 | 4227 | 58 |
1249138 | 1249138 | 2021-04-23 | Clinton | Iowa | 19045 | 5423 | 91 |
1249347 | 1249347 | 2021-04-23 | Clinton | Kentucky | 21053 | 1448 | 32 |
1249581 | 1249581 | 2021-04-23 | Clinton | Michigan | 26037 | 7080 | 80 |
1249841 | 1249841 | 2021-04-23 | Clinton | Missouri | 29049 | 1941 | 65 |
1250175 | 1250175 | 2021-04-23 | Clinton | New York | 36019 | 4611 | 33 |
1250394 | 1250394 | 2021-04-23 | Clinton | Ohio | 39027 | 3647 | 60 |
1250601 | 1250601 | 2021-04-23 | Clinton | Pennsylvania | 42035 | 3457 | 61 |
1245687 | 1245687 | 2021-04-22 | Clinton | Illinois | 17027 | 5718 | 99 |
1245788 | 1245788 | 2021-04-22 | Clinton | Indiana | 18023 | 4223 | 58 |
1245891 | 1245891 | 2021-04-22 | Clinton | Iowa | 19045 | 5419 | 91 |
1246100 | 1246100 | 2021-04-22 | Clinton | Kentucky | 21053 | 1448 | 32 |
1246334 | 1246334 | 2021-04-22 | Clinton | Michigan | 26037 | 7029 | 80 |
1246594 | 1246594 | 2021-04-22 | Clinton | Missouri | 29049 | 1939 | 65 |
1246928 | 1246928 | 2021-04-22 | Clinton | New York | 36019 | 4591 | 33 |
1247147 | 1247147 | 2021-04-22 | Clinton | Ohio | 39027 | 3646 | 60 |
1247354 | 1247354 | 2021-04-22 | Clinton | Pennsylvania | 42035 | 3440 | 61 |
1242440 | 1242440 | 2021-04-21 | Clinton | Illinois | 17027 | 5708 | 99 |
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);