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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Clinton · 7,026 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430 | 2430 | 2020-03-15 | Clinton | Illinois | 17027 | 1 | 0 |
2871 | 2871 | 2020-03-16 | Clinton | Illinois | 17027 | 1 | 0 |
3360 | 3360 | 2020-03-17 | Clinton | Illinois | 17027 | 2 | 0 |
3541 | 3541 | 2020-03-17 | Clinton | New York | 36019 | 1 | 0 |
3923 | 3923 | 2020-03-18 | Clinton | Illinois | 17027 | 3 | 0 |
4138 | 4138 | 2020-03-18 | Clinton | New York | 36019 | 1 | 0 |
4599 | 4599 | 2020-03-19 | Clinton | Illinois | 17027 | 3 | 0 |
4744 | 4744 | 2020-03-19 | Clinton | Michigan | 26037 | 1 | 0 |
4867 | 4867 | 2020-03-19 | Clinton | New York | 36019 | 1 | 0 |
5404 | 5404 | 2020-03-20 | Clinton | Illinois | 17027 | 3 | 0 |
5563 | 5563 | 2020-03-20 | Clinton | Michigan | 26037 | 1 | 0 |
5713 | 5713 | 2020-03-20 | Clinton | New York | 36019 | 2 | 0 |
6338 | 6338 | 2020-03-21 | Clinton | Illinois | 17027 | 3 | 0 |
6528 | 6528 | 2020-03-21 | Clinton | Michigan | 26037 | 2 | 0 |
6707 | 6707 | 2020-03-21 | Clinton | New York | 36019 | 4 | 0 |
7388 | 7388 | 2020-03-22 | Clinton | Illinois | 17027 | 3 | 0 |
7605 | 7605 | 2020-03-22 | Clinton | Michigan | 26037 | 2 | 0 |
7800 | 7800 | 2020-03-22 | Clinton | New York | 36019 | 4 | 0 |
7897 | 7897 | 2020-03-22 | Clinton | Ohio | 39027 | 1 | 0 |
8543 | 8543 | 2020-03-23 | Clinton | Illinois | 17027 | 3 | 0 |
8778 | 8778 | 2020-03-23 | Clinton | Michigan | 26037 | 2 | 0 |
8901 | 8901 | 2020-03-23 | Clinton | Missouri | 29049 | 1 | 0 |
8998 | 8998 | 2020-03-23 | Clinton | New York | 36019 | 6 | 0 |
9100 | 9100 | 2020-03-23 | Clinton | Ohio | 39027 | 1 | 0 |
9806 | 9806 | 2020-03-24 | Clinton | Illinois | 17027 | 3 | 0 |
10067 | 10067 | 2020-03-24 | Clinton | Michigan | 26037 | 5 | 0 |
10200 | 10200 | 2020-03-24 | Clinton | Missouri | 29049 | 1 | 0 |
10305 | 10305 | 2020-03-24 | Clinton | New York | 36019 | 8 | 0 |
10413 | 10413 | 2020-03-24 | Clinton | Ohio | 39027 | 1 | 0 |
11196 | 11196 | 2020-03-25 | Clinton | Illinois | 17027 | 4 | 0 |
11479 | 11479 | 2020-03-25 | Clinton | Michigan | 26037 | 6 | 0 |
11621 | 11621 | 2020-03-25 | Clinton | Missouri | 29049 | 1 | 0 |
11740 | 11740 | 2020-03-25 | Clinton | New York | 36019 | 10 | 0 |
11860 | 11860 | 2020-03-25 | Clinton | Ohio | 39027 | 2 | 0 |
12751 | 12751 | 2020-03-26 | Clinton | Illinois | 17027 | 5 | 0 |
13060 | 13060 | 2020-03-26 | Clinton | Michigan | 26037 | 7 | 0 |
13219 | 13219 | 2020-03-26 | Clinton | Missouri | 29049 | 1 | 0 |
13343 | 13343 | 2020-03-26 | Clinton | New York | 36019 | 11 | 0 |
13467 | 13467 | 2020-03-26 | Clinton | Ohio | 39027 | 2 | 0 |
14427 | 14427 | 2020-03-27 | Clinton | Illinois | 17027 | 5 | 0 |
14470 | 14470 | 2020-03-27 | Clinton | Indiana | 18023 | 1 | 0 |
14543 | 14543 | 2020-03-27 | Clinton | Iowa | 19045 | 1 | 0 |
14769 | 14769 | 2020-03-27 | Clinton | Michigan | 26037 | 8 | 0 |
14944 | 14944 | 2020-03-27 | Clinton | Missouri | 29049 | 1 | 0 |
15077 | 15077 | 2020-03-27 | Clinton | New York | 36019 | 11 | 0 |
15204 | 15204 | 2020-03-27 | Clinton | Ohio | 39027 | 2 | 0 |
16221 | 16221 | 2020-03-28 | Clinton | Illinois | 17027 | 5 | 0 |
16267 | 16267 | 2020-03-28 | Clinton | Indiana | 18023 | 1 | 0 |
16347 | 16347 | 2020-03-28 | Clinton | Iowa | 19045 | 1 | 0 |
16589 | 16589 | 2020-03-28 | Clinton | Michigan | 26037 | 13 | 0 |
16768 | 16768 | 2020-03-28 | Clinton | Missouri | 29049 | 1 | 0 |
16907 | 16907 | 2020-03-28 | Clinton | New York | 36019 | 12 | 0 |
17046 | 17046 | 2020-03-28 | Clinton | Ohio | 39027 | 3 | 0 |
18120 | 18120 | 2020-03-29 | Clinton | Illinois | 17027 | 6 | 0 |
18169 | 18169 | 2020-03-29 | Clinton | Indiana | 18023 | 1 | 0 |
18252 | 18252 | 2020-03-29 | Clinton | Iowa | 19045 | 1 | 0 |
18505 | 18505 | 2020-03-29 | Clinton | Michigan | 26037 | 14 | 0 |
18690 | 18690 | 2020-03-29 | Clinton | Missouri | 29049 | 1 | 0 |
18831 | 18831 | 2020-03-29 | Clinton | New York | 36019 | 13 | 0 |
18980 | 18980 | 2020-03-29 | Clinton | Ohio | 39027 | 3 | 0 |
20121 | 20121 | 2020-03-30 | Clinton | Illinois | 17027 | 6 | 0 |
20175 | 20175 | 2020-03-30 | Clinton | Indiana | 18023 | 1 | 0 |
20259 | 20259 | 2020-03-30 | Clinton | Iowa | 19045 | 2 | 0 |
20522 | 20522 | 2020-03-30 | Clinton | Michigan | 26037 | 19 | 0 |
20715 | 20715 | 2020-03-30 | Clinton | Missouri | 29049 | 4 | 0 |
20870 | 20870 | 2020-03-30 | Clinton | New York | 36019 | 17 | 0 |
21024 | 21024 | 2020-03-30 | Clinton | Ohio | 39027 | 3 | 0 |
22212 | 22212 | 2020-03-31 | Clinton | Illinois | 17027 | 7 | 0 |
22269 | 22269 | 2020-03-31 | Clinton | Indiana | 18023 | 1 | 0 |
22355 | 22355 | 2020-03-31 | Clinton | Iowa | 19045 | 5 | 0 |
22633 | 22633 | 2020-03-31 | Clinton | Michigan | 26037 | 24 | 0 |
22833 | 22833 | 2020-03-31 | Clinton | Missouri | 29049 | 4 | 0 |
22993 | 22993 | 2020-03-31 | Clinton | New York | 36019 | 21 | 0 |
23156 | 23156 | 2020-03-31 | Clinton | Ohio | 39027 | 3 | 0 |
24380 | 24380 | 2020-04-01 | Clinton | Illinois | 17027 | 8 | 0 |
24439 | 24439 | 2020-04-01 | Clinton | Indiana | 18023 | 1 | 0 |
24527 | 24527 | 2020-04-01 | Clinton | Iowa | 19045 | 6 | 0 |
24812 | 24812 | 2020-04-01 | Clinton | Michigan | 26037 | 33 | 0 |
25019 | 25019 | 2020-04-01 | Clinton | Missouri | 29049 | 5 | 0 |
25187 | 25187 | 2020-04-01 | Clinton | New York | 36019 | 25 | 0 |
25351 | 25351 | 2020-04-01 | Clinton | Ohio | 39027 | 4 | 0 |
26613 | 26613 | 2020-04-02 | Clinton | Illinois | 17027 | 8 | 0 |
26678 | 26678 | 2020-04-02 | Clinton | Indiana | 18023 | 1 | 0 |
26768 | 26768 | 2020-04-02 | Clinton | Iowa | 19045 | 9 | 0 |
27064 | 27064 | 2020-04-02 | Clinton | Michigan | 26037 | 43 | 1 |
27274 | 27274 | 2020-04-02 | Clinton | Missouri | 29049 | 6 | 0 |
27447 | 27447 | 2020-04-02 | Clinton | New York | 36019 | 25 | 0 |
27617 | 27617 | 2020-04-02 | Clinton | Ohio | 39027 | 5 | 0 |
28920 | 28920 | 2020-04-03 | Clinton | Illinois | 17027 | 8 | 0 |
28988 | 28988 | 2020-04-03 | Clinton | Indiana | 18023 | 3 | 0 |
29079 | 29079 | 2020-04-03 | Clinton | Iowa | 19045 | 15 | 0 |
29382 | 29382 | 2020-04-03 | Clinton | Michigan | 26037 | 49 | 1 |
29594 | 29594 | 2020-04-03 | Clinton | Missouri | 29049 | 8 | 0 |
29771 | 29771 | 2020-04-03 | Clinton | New York | 36019 | 25 | 0 |
29946 | 29946 | 2020-04-03 | Clinton | Ohio | 39027 | 7 | 0 |
30108 | 30108 | 2020-04-03 | Clinton | Pennsylvania | 42035 | 1 | 0 |
31282 | 31282 | 2020-04-04 | Clinton | Illinois | 17027 | 10 | 0 |
31354 | 31354 | 2020-04-04 | Clinton | Indiana | 18023 | 3 | 0 |
31447 | 31447 | 2020-04-04 | Clinton | Iowa | 19045 | 15 | 0 |
31569 | 31569 | 2020-04-04 | Clinton | Kentucky | 21053 | 1 | 0 |
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);