ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Adams", fips = 18001 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1058 | 1058 | 2020-03-10 | Adams | Indiana | 18001 | 1 | 0 |
1233 | 1233 | 2020-03-11 | Adams | Indiana | 18001 | 1 | 0 |
1447 | 1447 | 2020-03-12 | Adams | Indiana | 18001 | 1 | 0 |
1718 | 1718 | 2020-03-13 | Adams | Indiana | 18001 | 1 | 0 |
2049 | 2049 | 2020-03-14 | Adams | Indiana | 18001 | 1 | 0 |
2442 | 2442 | 2020-03-15 | Adams | Indiana | 18001 | 1 | 0 |
2885 | 2885 | 2020-03-16 | Adams | Indiana | 18001 | 1 | 0 |
3374 | 3374 | 2020-03-17 | Adams | Indiana | 18001 | 1 | 0 |
3944 | 3944 | 2020-03-18 | Adams | Indiana | 18001 | 1 | 0 |
4620 | 4620 | 2020-03-19 | Adams | Indiana | 18001 | 1 | 0 |
5426 | 5426 | 2020-03-20 | Adams | Indiana | 18001 | 1 | 0 |
6361 | 6361 | 2020-03-21 | Adams | Indiana | 18001 | 1 | 0 |
7415 | 7415 | 2020-03-22 | Adams | Indiana | 18001 | 1 | 0 |
8572 | 8572 | 2020-03-23 | Adams | Indiana | 18001 | 1 | 0 |
9836 | 9836 | 2020-03-24 | Adams | Indiana | 18001 | 1 | 0 |
11229 | 11229 | 2020-03-25 | Adams | Indiana | 18001 | 1 | 0 |
12785 | 12785 | 2020-03-26 | Adams | Indiana | 18001 | 1 | 0 |
14463 | 14463 | 2020-03-27 | Adams | Indiana | 18001 | 1 | 0 |
16260 | 16260 | 2020-03-28 | Adams | Indiana | 18001 | 1 | 0 |
18161 | 18161 | 2020-03-29 | Adams | Indiana | 18001 | 1 | 0 |
20167 | 20167 | 2020-03-30 | Adams | Indiana | 18001 | 1 | 0 |
22260 | 22260 | 2020-03-31 | Adams | Indiana | 18001 | 1 | 0 |
24430 | 24430 | 2020-04-01 | Adams | Indiana | 18001 | 1 | 0 |
26668 | 26668 | 2020-04-02 | Adams | Indiana | 18001 | 1 | 0 |
28978 | 28978 | 2020-04-03 | Adams | Indiana | 18001 | 1 | 0 |
31344 | 31344 | 2020-04-04 | Adams | Indiana | 18001 | 2 | 0 |
33754 | 33754 | 2020-04-05 | Adams | Indiana | 18001 | 2 | 0 |
36207 | 36207 | 2020-04-06 | Adams | Indiana | 18001 | 2 | 0 |
38705 | 38705 | 2020-04-07 | Adams | Indiana | 18001 | 2 | 0 |
41251 | 41251 | 2020-04-08 | Adams | Indiana | 18001 | 2 | 0 |
43827 | 43827 | 2020-04-09 | Adams | Indiana | 18001 | 2 | 0 |
46431 | 46431 | 2020-04-10 | Adams | Indiana | 18001 | 4 | 0 |
49065 | 49065 | 2020-04-11 | Adams | Indiana | 18001 | 4 | 0 |
51727 | 51727 | 2020-04-12 | Adams | Indiana | 18001 | 5 | 1 |
54408 | 54408 | 2020-04-13 | Adams | Indiana | 18001 | 5 | 1 |
57101 | 57101 | 2020-04-14 | Adams | Indiana | 18001 | 6 | 1 |
59809 | 59809 | 2020-04-15 | Adams | Indiana | 18001 | 6 | 1 |
62530 | 62530 | 2020-04-16 | Adams | Indiana | 18001 | 6 | 1 |
65264 | 65264 | 2020-04-17 | Adams | Indiana | 18001 | 6 | 1 |
68013 | 68013 | 2020-04-18 | Adams | Indiana | 18001 | 7 | 1 |
70775 | 70775 | 2020-04-19 | Adams | Indiana | 18001 | 7 | 1 |
73546 | 73546 | 2020-04-20 | Adams | Indiana | 18001 | 7 | 1 |
76323 | 76323 | 2020-04-21 | Adams | Indiana | 18001 | 7 | 1 |
79107 | 79107 | 2020-04-22 | Adams | Indiana | 18001 | 7 | 1 |
81900 | 81900 | 2020-04-23 | Adams | Indiana | 18001 | 7 | 1 |
84700 | 84700 | 2020-04-24 | Adams | Indiana | 18001 | 7 | 1 |
87510 | 87510 | 2020-04-25 | Adams | Indiana | 18001 | 7 | 1 |
90326 | 90326 | 2020-04-26 | Adams | Indiana | 18001 | 8 | 1 |
93145 | 93145 | 2020-04-27 | Adams | Indiana | 18001 | 7 | 1 |
95977 | 95977 | 2020-04-28 | Adams | Indiana | 18001 | 7 | 1 |
98821 | 98821 | 2020-04-29 | Adams | Indiana | 18001 | 7 | 1 |
101672 | 101672 | 2020-04-30 | Adams | Indiana | 18001 | 7 | 1 |
104528 | 104528 | 2020-05-01 | Adams | Indiana | 18001 | 7 | 1 |
107393 | 107393 | 2020-05-02 | Adams | Indiana | 18001 | 8 | 1 |
110263 | 110263 | 2020-05-03 | Adams | Indiana | 18001 | 8 | 1 |
113138 | 113138 | 2020-05-04 | Adams | Indiana | 18001 | 8 | 1 |
116021 | 116021 | 2020-05-05 | Adams | Indiana | 18001 | 9 | 1 |
118981 | 118981 | 2020-05-06 | Adams | Indiana | 18001 | 8 | 1 |
121951 | 121951 | 2020-05-07 | Adams | Indiana | 18001 | 8 | 1 |
124931 | 124931 | 2020-05-08 | Adams | Indiana | 18001 | 8 | 1 |
127918 | 127918 | 2020-05-09 | Adams | Indiana | 18001 | 8 | 1 |
130909 | 130909 | 2020-05-10 | Adams | Indiana | 18001 | 8 | 1 |
133899 | 133899 | 2020-05-11 | Adams | Indiana | 18001 | 8 | 1 |
136888 | 136888 | 2020-05-12 | Adams | Indiana | 18001 | 8 | 1 |
139880 | 139880 | 2020-05-13 | Adams | Indiana | 18001 | 8 | 1 |
142876 | 142876 | 2020-05-14 | Adams | Indiana | 18001 | 9 | 1 |
145876 | 145876 | 2020-05-15 | Adams | Indiana | 18001 | 9 | 1 |
148880 | 148880 | 2020-05-16 | Adams | Indiana | 18001 | 9 | 1 |
151889 | 151889 | 2020-05-17 | Adams | Indiana | 18001 | 9 | 1 |
154901 | 154901 | 2020-05-18 | Adams | Indiana | 18001 | 10 | 1 |
157917 | 157917 | 2020-05-19 | Adams | Indiana | 18001 | 10 | 1 |
160943 | 160943 | 2020-05-20 | Adams | Indiana | 18001 | 11 | 1 |
163971 | 163971 | 2020-05-21 | Adams | Indiana | 18001 | 11 | 1 |
167004 | 167004 | 2020-05-22 | Adams | Indiana | 18001 | 11 | 1 |
170041 | 170041 | 2020-05-23 | Adams | Indiana | 18001 | 12 | 1 |
173082 | 173082 | 2020-05-24 | Adams | Indiana | 18001 | 12 | 1 |
176126 | 176126 | 2020-05-25 | Adams | Indiana | 18001 | 12 | 1 |
179170 | 179170 | 2020-05-26 | Adams | Indiana | 18001 | 12 | 1 |
182214 | 182214 | 2020-05-27 | Adams | Indiana | 18001 | 12 | 1 |
185268 | 185268 | 2020-05-28 | Adams | Indiana | 18001 | 13 | 1 |
188326 | 188326 | 2020-05-29 | Adams | Indiana | 18001 | 13 | 1 |
191391 | 191391 | 2020-05-30 | Adams | Indiana | 18001 | 17 | 1 |
194458 | 194458 | 2020-05-31 | Adams | Indiana | 18001 | 15 | 1 |
197528 | 197528 | 2020-06-01 | Adams | Indiana | 18001 | 17 | 1 |
200601 | 200601 | 2020-06-02 | Adams | Indiana | 18001 | 20 | 1 |
203677 | 203677 | 2020-06-03 | Adams | Indiana | 18001 | 20 | 1 |
206757 | 206757 | 2020-06-04 | Adams | Indiana | 18001 | 21 | 1 |
209838 | 209838 | 2020-06-05 | Adams | Indiana | 18001 | 23 | 1 |
212923 | 212923 | 2020-06-06 | Adams | Indiana | 18001 | 22 | 1 |
216010 | 216010 | 2020-06-07 | Adams | Indiana | 18001 | 22 | 1 |
219102 | 219102 | 2020-06-08 | Adams | Indiana | 18001 | 22 | 1 |
222197 | 222197 | 2020-06-09 | Adams | Indiana | 18001 | 23 | 1 |
225292 | 225292 | 2020-06-10 | Adams | Indiana | 18001 | 24 | 1 |
228394 | 228394 | 2020-06-11 | Adams | Indiana | 18001 | 24 | 1 |
231497 | 231497 | 2020-06-12 | Adams | Indiana | 18001 | 24 | 1 |
234603 | 234603 | 2020-06-13 | Adams | Indiana | 18001 | 25 | 1 |
237710 | 237710 | 2020-06-14 | Adams | Indiana | 18001 | 26 | 1 |
240818 | 240818 | 2020-06-15 | Adams | Indiana | 18001 | 27 | 1 |
243929 | 243929 | 2020-06-16 | Adams | Indiana | 18001 | 28 | 1 |
247042 | 247042 | 2020-06-17 | Adams | Indiana | 18001 | 29 | 2 |
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);