ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,212 rows where county = "Adams" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Colorado 792
- Pennsylvania 785
- Washington 779
- Mississippi 778
- Nebraska 775
- Illinois 770
- Ohio 767
- Wisconsin 767
- Indiana 766
- Idaho 754
- Iowa 724
- North Dakota 655
fips 12
county 1
- Adams · 9,112 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
39741 | 39741 | 2020-04-07 | Adams | Ohio | 39001 | 2 | 0 |
40548 | 40548 | 2020-04-07 | Adams | Wisconsin | 55001 | 2 | 0 |
41251 | 41251 | 2020-04-08 | Adams | Indiana | 18001 | 2 | 0 |
42299 | 42299 | 2020-04-08 | Adams | Ohio | 39001 | 2 | 0 |
43120 | 43120 | 2020-04-08 | Adams | Wisconsin | 55001 | 2 | 0 |
43827 | 43827 | 2020-04-09 | Adams | Indiana | 18001 | 2 | 0 |
45717 | 45717 | 2020-04-09 | Adams | Wisconsin | 55001 | 2 | 0 |
48345 | 48345 | 2020-04-10 | Adams | Wisconsin | 55001 | 2 | 0 |
51005 | 51005 | 2020-04-11 | Adams | Wisconsin | 55001 | 2 | 0 |
53682 | 53682 | 2020-04-12 | Adams | Wisconsin | 55001 | 2 | 0 |
378269 | 378269 | 2020-07-28 | Adams | North Dakota | 38001 | 2 | 0 |
381486 | 381486 | 2020-07-29 | Adams | North Dakota | 38001 | 2 | 0 |
384704 | 384704 | 2020-07-30 | Adams | North Dakota | 38001 | 2 | 0 |
387921 | 387921 | 2020-07-31 | Adams | North Dakota | 38001 | 2 | 0 |
391138 | 391138 | 2020-08-01 | Adams | North Dakota | 38001 | 2 | 0 |
394354 | 394354 | 2020-08-02 | Adams | North Dakota | 38001 | 2 | 0 |
397571 | 397571 | 2020-08-03 | Adams | North Dakota | 38001 | 2 | 0 |
400786 | 400786 | 2020-08-04 | Adams | North Dakota | 38001 | 2 | 0 |
404004 | 404004 | 2020-08-05 | Adams | North Dakota | 38001 | 2 | 0 |
407223 | 407223 | 2020-08-06 | Adams | North Dakota | 38001 | 2 | 0 |
410443 | 410443 | 2020-08-07 | Adams | North Dakota | 38001 | 2 | 0 |
413663 | 413663 | 2020-08-08 | Adams | North Dakota | 38001 | 2 | 0 |
416884 | 416884 | 2020-08-09 | Adams | North Dakota | 38001 | 2 | 0 |
1657 | 1657 | 2020-03-13 | Adams | Colorado | 8001 | 3 | 0 |
13143 | 13143 | 2020-03-26 | Adams | Mississippi | 28001 | 3 | 0 |
13925 | 13925 | 2020-03-26 | Adams | Washington | 53001 | 3 | 0 |
20782 | 20782 | 2020-03-30 | Adams | Nebraska | 31001 | 3 | 0 |
22905 | 22905 | 2020-03-31 | Adams | Nebraska | 31001 | 3 | 0 |
31275 | 31275 | 2020-04-04 | Adams | Illinois | 17001 | 3 | 0 |
33682 | 33682 | 2020-04-05 | Adams | Illinois | 17001 | 3 | 0 |
44884 | 44884 | 2020-04-09 | Adams | Ohio | 39001 | 3 | 0 |
47499 | 47499 | 2020-04-10 | Adams | Ohio | 39001 | 3 | 0 |
50154 | 50154 | 2020-04-11 | Adams | Ohio | 39001 | 3 | 0 |
52827 | 52827 | 2020-04-12 | Adams | Ohio | 39001 | 3 | 0 |
55511 | 55511 | 2020-04-13 | Adams | Ohio | 39001 | 3 | 0 |
56372 | 56372 | 2020-04-13 | Adams | Wisconsin | 55001 | 3 | 0 |
58212 | 58212 | 2020-04-14 | Adams | Ohio | 39001 | 3 | 0 |
59079 | 59079 | 2020-04-14 | Adams | Wisconsin | 55001 | 3 | 1 |
60926 | 60926 | 2020-04-15 | Adams | Ohio | 39001 | 3 | 0 |
61798 | 61798 | 2020-04-15 | Adams | Wisconsin | 55001 | 3 | 1 |
63652 | 63652 | 2020-04-16 | Adams | Ohio | 39001 | 3 | 0 |
64531 | 64531 | 2020-04-16 | Adams | Wisconsin | 55001 | 3 | 1 |
66395 | 66395 | 2020-04-17 | Adams | Ohio | 39001 | 3 | 0 |
69152 | 69152 | 2020-04-18 | Adams | Ohio | 39001 | 3 | 0 |
71919 | 71919 | 2020-04-19 | Adams | Ohio | 39001 | 3 | 0 |
73419 | 73419 | 2020-04-20 | Adams | Idaho | 16003 | 3 | 0 |
74694 | 74694 | 2020-04-20 | Adams | Ohio | 39001 | 3 | 0 |
76195 | 76195 | 2020-04-21 | Adams | Idaho | 16003 | 3 | 0 |
77475 | 77475 | 2020-04-21 | Adams | Ohio | 39001 | 3 | 0 |
78979 | 78979 | 2020-04-22 | Adams | Idaho | 16003 | 3 | 0 |
81772 | 81772 | 2020-04-23 | Adams | Idaho | 16003 | 3 | 0 |
84572 | 84572 | 2020-04-24 | Adams | Idaho | 16003 | 3 | 0 |
87381 | 87381 | 2020-04-25 | Adams | Idaho | 16003 | 3 | 0 |
90197 | 90197 | 2020-04-26 | Adams | Idaho | 16003 | 3 | 0 |
93016 | 93016 | 2020-04-27 | Adams | Idaho | 16003 | 3 | 0 |
95848 | 95848 | 2020-04-28 | Adams | Idaho | 16003 | 3 | 0 |
98692 | 98692 | 2020-04-29 | Adams | Idaho | 16003 | 3 | 0 |
101543 | 101543 | 2020-04-30 | Adams | Idaho | 16003 | 3 | 0 |
104398 | 104398 | 2020-05-01 | Adams | Idaho | 16003 | 3 | 0 |
107263 | 107263 | 2020-05-02 | Adams | Idaho | 16003 | 3 | 0 |
110133 | 110133 | 2020-05-03 | Adams | Idaho | 16003 | 3 | 0 |
113008 | 113008 | 2020-05-04 | Adams | Idaho | 16003 | 3 | 0 |
115891 | 115891 | 2020-05-05 | Adams | Idaho | 16003 | 3 | 0 |
118851 | 118851 | 2020-05-06 | Adams | Idaho | 16003 | 3 | 0 |
121821 | 121821 | 2020-05-07 | Adams | Idaho | 16003 | 3 | 0 |
124800 | 124800 | 2020-05-08 | Adams | Idaho | 16003 | 3 | 0 |
127787 | 127787 | 2020-05-09 | Adams | Idaho | 16003 | 3 | 0 |
130778 | 130778 | 2020-05-10 | Adams | Idaho | 16003 | 3 | 0 |
133769 | 133769 | 2020-05-11 | Adams | Idaho | 16003 | 3 | 0 |
136758 | 136758 | 2020-05-12 | Adams | Idaho | 16003 | 3 | 0 |
139749 | 139749 | 2020-05-13 | Adams | Idaho | 16003 | 3 | 0 |
142745 | 142745 | 2020-05-14 | Adams | Idaho | 16003 | 3 | 0 |
145745 | 145745 | 2020-05-15 | Adams | Idaho | 16003 | 3 | 0 |
148748 | 148748 | 2020-05-16 | Adams | Idaho | 16003 | 3 | 0 |
151757 | 151757 | 2020-05-17 | Adams | Idaho | 16003 | 3 | 0 |
154769 | 154769 | 2020-05-18 | Adams | Idaho | 16003 | 3 | 0 |
157785 | 157785 | 2020-05-19 | Adams | Idaho | 16003 | 3 | 0 |
160811 | 160811 | 2020-05-20 | Adams | Idaho | 16003 | 3 | 0 |
161036 | 161036 | 2020-05-20 | Adams | Iowa | 19003 | 3 | 0 |
163839 | 163839 | 2020-05-21 | Adams | Idaho | 16003 | 3 | 0 |
164064 | 164064 | 2020-05-21 | Adams | Iowa | 19003 | 3 | 0 |
166872 | 166872 | 2020-05-22 | Adams | Idaho | 16003 | 3 | 0 |
169909 | 169909 | 2020-05-23 | Adams | Idaho | 16003 | 3 | 0 |
172950 | 172950 | 2020-05-24 | Adams | Idaho | 16003 | 3 | 0 |
175993 | 175993 | 2020-05-25 | Adams | Idaho | 16003 | 3 | 0 |
179037 | 179037 | 2020-05-26 | Adams | Idaho | 16003 | 3 | 0 |
182081 | 182081 | 2020-05-27 | Adams | Idaho | 16003 | 3 | 0 |
185135 | 185135 | 2020-05-28 | Adams | Idaho | 16003 | 3 | 0 |
188191 | 188191 | 2020-05-29 | Adams | Idaho | 16003 | 3 | 0 |
191256 | 191256 | 2020-05-30 | Adams | Idaho | 16003 | 3 | 0 |
194323 | 194323 | 2020-05-31 | Adams | Idaho | 16003 | 3 | 0 |
197393 | 197393 | 2020-06-01 | Adams | Idaho | 16003 | 3 | 0 |
200466 | 200466 | 2020-06-02 | Adams | Idaho | 16003 | 3 | 0 |
203542 | 203542 | 2020-06-03 | Adams | Idaho | 16003 | 3 | 0 |
206622 | 206622 | 2020-06-04 | Adams | Idaho | 16003 | 3 | 0 |
209703 | 209703 | 2020-06-05 | Adams | Idaho | 16003 | 3 | 0 |
212788 | 212788 | 2020-06-06 | Adams | Idaho | 16003 | 3 | 0 |
215875 | 215875 | 2020-06-07 | Adams | Idaho | 16003 | 3 | 0 |
218966 | 218966 | 2020-06-08 | Adams | Idaho | 16003 | 3 | 0 |
222061 | 222061 | 2020-06-09 | Adams | Idaho | 16003 | 3 | 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);