ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,750 rows where county = "Hamilton" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1872 | 1872 | 2020-03-13 | Hamilton | Tennessee | 47065 | 1 | 0 |
2237 | 2237 | 2020-03-14 | Hamilton | Tennessee | 47065 | 1 | 0 |
2444 | 2444 | 2020-03-15 | Hamilton | Indiana | 18057 | 1 | 0 |
2662 | 2662 | 2020-03-15 | Hamilton | Tennessee | 47065 | 1 | 0 |
2889 | 2889 | 2020-03-16 | Hamilton | Indiana | 18057 | 1 | 0 |
3128 | 3128 | 2020-03-16 | Hamilton | Tennessee | 47065 | 1 | 0 |
3379 | 3379 | 2020-03-17 | Hamilton | Indiana | 18057 | 1 | 0 |
3661 | 3661 | 2020-03-17 | Hamilton | Tennessee | 47065 | 1 | 0 |
3951 | 3951 | 2020-03-18 | Hamilton | Indiana | 18057 | 2 | 0 |
4144 | 4144 | 2020-03-18 | Hamilton | New York | 36041 | 1 | 0 |
4282 | 4282 | 2020-03-18 | Hamilton | Tennessee | 47065 | 1 | 0 |
4627 | 4627 | 2020-03-19 | Hamilton | Indiana | 18057 | 2 | 0 |
4873 | 4873 | 2020-03-19 | Hamilton | New York | 36041 | 1 | 0 |
4936 | 4936 | 2020-03-19 | Hamilton | Ohio | 39061 | 2 | 0 |
5029 | 5029 | 2020-03-19 | Hamilton | Tennessee | 47065 | 1 | 0 |
5435 | 5435 | 2020-03-20 | Hamilton | Indiana | 18057 | 5 | 0 |
5722 | 5722 | 2020-03-20 | Hamilton | New York | 36041 | 2 | 0 |
5799 | 5799 | 2020-03-20 | Hamilton | Ohio | 39061 | 7 | 0 |
5916 | 5916 | 2020-03-20 | Hamilton | Tennessee | 47065 | 5 | 0 |
6372 | 6372 | 2020-03-21 | Hamilton | Indiana | 18057 | 10 | 0 |
6716 | 6716 | 2020-03-21 | Hamilton | New York | 36041 | 2 | 0 |
6799 | 6799 | 2020-03-21 | Hamilton | Ohio | 39061 | 8 | 0 |
6929 | 6929 | 2020-03-21 | Hamilton | Tennessee | 47065 | 7 | 0 |
7426 | 7426 | 2020-03-22 | Hamilton | Indiana | 18057 | 18 | 0 |
7810 | 7810 | 2020-03-22 | Hamilton | New York | 36041 | 2 | 0 |
7909 | 7909 | 2020-03-22 | Hamilton | Ohio | 39061 | 19 | 0 |
8054 | 8054 | 2020-03-22 | Hamilton | Tennessee | 47065 | 8 | 0 |
8584 | 8584 | 2020-03-23 | Hamilton | Indiana | 18057 | 21 | 0 |
9008 | 9008 | 2020-03-23 | Hamilton | New York | 36041 | 2 | 0 |
9112 | 9112 | 2020-03-23 | Hamilton | Ohio | 39061 | 26 | 0 |
9272 | 9272 | 2020-03-23 | Hamilton | Tennessee | 47065 | 8 | 0 |
9852 | 9852 | 2020-03-24 | Hamilton | Indiana | 18057 | 25 | 0 |
10315 | 10315 | 2020-03-24 | Hamilton | New York | 36041 | 2 | 0 |
10427 | 10427 | 2020-03-24 | Hamilton | Ohio | 39061 | 38 | 0 |
10602 | 10602 | 2020-03-24 | Hamilton | Tennessee | 47065 | 8 | 0 |
11246 | 11246 | 2020-03-25 | Hamilton | Indiana | 18057 | 30 | 0 |
11751 | 11751 | 2020-03-25 | Hamilton | New York | 36041 | 2 | 0 |
11875 | 11875 | 2020-03-25 | Hamilton | Ohio | 39061 | 48 | 0 |
12079 | 12079 | 2020-03-25 | Hamilton | Tennessee | 47065 | 15 | 0 |
12803 | 12803 | 2020-03-26 | Hamilton | Indiana | 18057 | 40 | 0 |
13354 | 13354 | 2020-03-26 | Hamilton | New York | 36041 | 2 | 0 |
13482 | 13482 | 2020-03-26 | Hamilton | Ohio | 39061 | 53 | 0 |
13703 | 13703 | 2020-03-26 | Hamilton | Tennessee | 47065 | 28 | 0 |
14484 | 14484 | 2020-03-27 | Hamilton | Indiana | 18057 | 53 | 0 |
15088 | 15088 | 2020-03-27 | Hamilton | New York | 36041 | 2 | 0 |
15220 | 15220 | 2020-03-27 | Hamilton | Ohio | 39061 | 63 | 0 |
15455 | 15455 | 2020-03-27 | Hamilton | Tennessee | 47065 | 30 | 0 |
16282 | 16282 | 2020-03-28 | Hamilton | Indiana | 18057 | 64 | 0 |
16918 | 16918 | 2020-03-28 | Hamilton | New York | 36041 | 2 | 0 |
17062 | 17062 | 2020-03-28 | Hamilton | Ohio | 39061 | 71 | 0 |
17316 | 17316 | 2020-03-28 | Hamilton | Tennessee | 47065 | 35 | 0 |
18185 | 18185 | 2020-03-29 | Hamilton | Indiana | 18057 | 83 | 0 |
18842 | 18842 | 2020-03-29 | Hamilton | New York | 36041 | 2 | 0 |
18996 | 18996 | 2020-03-29 | Hamilton | Ohio | 39061 | 85 | 0 |
19262 | 19262 | 2020-03-29 | Hamilton | Tennessee | 47065 | 35 | 0 |
20191 | 20191 | 2020-03-30 | Hamilton | Indiana | 18057 | 106 | 0 |
20881 | 20881 | 2020-03-30 | Hamilton | New York | 36041 | 2 | 0 |
21040 | 21040 | 2020-03-30 | Hamilton | Ohio | 39061 | 101 | 0 |
21317 | 21317 | 2020-03-30 | Hamilton | Tennessee | 47065 | 40 | 0 |
22285 | 22285 | 2020-03-31 | Hamilton | Indiana | 18057 | 127 | 0 |
23004 | 23004 | 2020-03-31 | Hamilton | New York | 36041 | 2 | 0 |
23172 | 23172 | 2020-03-31 | Hamilton | Ohio | 39061 | 124 | 0 |
23455 | 23455 | 2020-03-31 | Hamilton | Tennessee | 47065 | 48 | 0 |
24455 | 24455 | 2020-04-01 | Hamilton | Indiana | 18057 | 179 | 4 |
25198 | 25198 | 2020-04-01 | Hamilton | New York | 36041 | 2 | 0 |
25367 | 25367 | 2020-04-01 | Hamilton | Ohio | 39061 | 154 | 0 |
25655 | 25655 | 2020-04-01 | Hamilton | Tennessee | 47065 | 50 | 2 |
26694 | 26694 | 2020-04-02 | Hamilton | Indiana | 18057 | 207 | 4 |
27362 | 27362 | 2020-04-02 | Hamilton | Nebraska | 31081 | 2 | 0 |
27458 | 27458 | 2020-04-02 | Hamilton | New York | 36041 | 2 | 0 |
27634 | 27634 | 2020-04-02 | Hamilton | Ohio | 39061 | 178 | 2 |
27933 | 27933 | 2020-04-02 | Hamilton | Tennessee | 47065 | 61 | 3 |
29004 | 29004 | 2020-04-03 | Hamilton | Indiana | 18057 | 220 | 4 |
29685 | 29685 | 2020-04-03 | Hamilton | Nebraska | 31081 | 3 | 0 |
29782 | 29782 | 2020-04-03 | Hamilton | New York | 36041 | 2 | 0 |
29963 | 29963 | 2020-04-03 | Hamilton | Ohio | 39061 | 220 | 2 |
30268 | 30268 | 2020-04-03 | Hamilton | Tennessee | 47065 | 67 | 3 |
31370 | 31370 | 2020-04-04 | Hamilton | Indiana | 18057 | 265 | 4 |
32068 | 32068 | 2020-04-04 | Hamilton | Nebraska | 31081 | 4 | 0 |
32168 | 32168 | 2020-04-04 | Hamilton | New York | 36041 | 2 | 0 |
32352 | 32352 | 2020-04-04 | Hamilton | Ohio | 39061 | 288 | 2 |
32659 | 32659 | 2020-04-04 | Hamilton | Tennessee | 47065 | 71 | 8 |
33781 | 33781 | 2020-04-05 | Hamilton | Indiana | 18057 | 300 | 5 |
33868 | 33868 | 2020-04-05 | Hamilton | Iowa | 19079 | 1 | 0 |
34496 | 34496 | 2020-04-05 | Hamilton | Nebraska | 31081 | 6 | 0 |
34599 | 34599 | 2020-04-05 | Hamilton | New York | 36041 | 2 | 0 |
34785 | 34785 | 2020-04-05 | Hamilton | Ohio | 39061 | 319 | 3 |
35095 | 35095 | 2020-04-05 | Hamilton | Tennessee | 47065 | 79 | 8 |
35898 | 35898 | 2020-04-06 | Hamilton | Florida | 12047 | 1 | 0 |
36234 | 36234 | 2020-04-06 | Hamilton | Indiana | 18057 | 335 | 5 |
36323 | 36323 | 2020-04-06 | Hamilton | Iowa | 19079 | 1 | 0 |
36965 | 36965 | 2020-04-06 | Hamilton | Nebraska | 31081 | 6 | 0 |
37069 | 37069 | 2020-04-06 | Hamilton | New York | 36041 | 2 | 0 |
37254 | 37254 | 2020-04-06 | Hamilton | Ohio | 39061 | 394 | 9 |
37571 | 37571 | 2020-04-06 | Hamilton | Tennessee | 47065 | 83 | 9 |
38389 | 38389 | 2020-04-07 | Hamilton | Florida | 12047 | 1 | 0 |
38732 | 38732 | 2020-04-07 | Hamilton | Indiana | 18057 | 363 | 10 |
38824 | 38824 | 2020-04-07 | Hamilton | Iowa | 19079 | 2 | 0 |
39481 | 39481 | 2020-04-07 | Hamilton | Nebraska | 31081 | 7 | 0 |
39584 | 39584 | 2020-04-07 | Hamilton | New York | 36041 | 2 | 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);