ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Niagara" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5730 | 5730 | 2020-03-20 | Niagara | New York | 36063 | 3 | 0 |
6724 | 6724 | 2020-03-21 | Niagara | New York | 36063 | 4 | 0 |
7819 | 7819 | 2020-03-22 | Niagara | New York | 36063 | 6 | 0 |
9017 | 9017 | 2020-03-23 | Niagara | New York | 36063 | 10 | 0 |
10324 | 10324 | 2020-03-24 | Niagara | New York | 36063 | 11 | 0 |
11760 | 11760 | 2020-03-25 | Niagara | New York | 36063 | 12 | 0 |
13363 | 13363 | 2020-03-26 | Niagara | New York | 36063 | 14 | 0 |
15097 | 15097 | 2020-03-27 | Niagara | New York | 36063 | 23 | 0 |
16927 | 16927 | 2020-03-28 | Niagara | New York | 36063 | 33 | 0 |
18852 | 18852 | 2020-03-29 | Niagara | New York | 36063 | 38 | 0 |
20891 | 20891 | 2020-03-30 | Niagara | New York | 36063 | 41 | 0 |
23014 | 23014 | 2020-03-31 | Niagara | New York | 36063 | 42 | 0 |
25208 | 25208 | 2020-04-01 | Niagara | New York | 36063 | 46 | 0 |
27468 | 27468 | 2020-04-02 | Niagara | New York | 36063 | 91 | 0 |
29792 | 29792 | 2020-04-03 | Niagara | New York | 36063 | 91 | 0 |
32178 | 32178 | 2020-04-04 | Niagara | New York | 36063 | 103 | 0 |
34609 | 34609 | 2020-04-05 | Niagara | New York | 36063 | 116 | 0 |
37079 | 37079 | 2020-04-06 | Niagara | New York | 36063 | 130 | 0 |
39594 | 39594 | 2020-04-07 | Niagara | New York | 36063 | 143 | 0 |
42151 | 42151 | 2020-04-08 | Niagara | New York | 36063 | 143 | 0 |
44734 | 44734 | 2020-04-09 | Niagara | New York | 36063 | 146 | 0 |
47347 | 47347 | 2020-04-10 | Niagara | New York | 36063 | 156 | 1 |
50002 | 50002 | 2020-04-11 | Niagara | New York | 36063 | 167 | 2 |
52675 | 52675 | 2020-04-12 | Niagara | New York | 36063 | 183 | 5 |
55358 | 55358 | 2020-04-13 | Niagara | New York | 36063 | 189 | 5 |
58058 | 58058 | 2020-04-14 | Niagara | New York | 36063 | 197 | 6 |
60772 | 60772 | 2020-04-15 | Niagara | New York | 36063 | 204 | 6 |
63498 | 63498 | 2020-04-16 | Niagara | New York | 36063 | 216 | 8 |
66240 | 66240 | 2020-04-17 | Niagara | New York | 36063 | 227 | 8 |
68997 | 68997 | 2020-04-18 | Niagara | New York | 36063 | 234 | 8 |
71764 | 71764 | 2020-04-19 | Niagara | New York | 36063 | 246 | 9 |
74539 | 74539 | 2020-04-20 | Niagara | New York | 36063 | 255 | 9 |
77320 | 77320 | 2020-04-21 | Niagara | New York | 36063 | 260 | 9 |
80109 | 80109 | 2020-04-22 | Niagara | New York | 36063 | 268 | 10 |
82908 | 82908 | 2020-04-23 | Niagara | New York | 36063 | 295 | 11 |
85712 | 85712 | 2020-04-24 | Niagara | New York | 36063 | 332 | 11 |
88524 | 88524 | 2020-04-25 | Niagara | New York | 36063 | 344 | 11 |
91339 | 91339 | 2020-04-26 | Niagara | New York | 36063 | 368 | 11 |
94164 | 94164 | 2020-04-27 | Niagara | New York | 36063 | 378 | 11 |
97000 | 97000 | 2020-04-28 | Niagara | New York | 36063 | 386 | 11 |
99847 | 99847 | 2020-04-29 | Niagara | New York | 36063 | 401 | 11 |
102700 | 102700 | 2020-04-30 | Niagara | New York | 36063 | 420 | 13 |
105562 | 105562 | 2020-05-01 | Niagara | New York | 36063 | 440 | 14 |
108429 | 108429 | 2020-05-02 | Niagara | New York | 36063 | 457 | 14 |
111302 | 111302 | 2020-05-03 | Niagara | New York | 36063 | 474 | 14 |
114183 | 114183 | 2020-05-04 | Niagara | New York | 36063 | 493 | 14 |
117063 | 117063 | 2020-05-05 | Niagara | New York | 36063 | 508 | 14 |
120024 | 120024 | 2020-05-06 | Niagara | New York | 36063 | 549 | 24 |
122999 | 122999 | 2020-05-07 | Niagara | New York | 36063 | 588 | 27 |
125982 | 125982 | 2020-05-08 | Niagara | New York | 36063 | 605 | 31 |
128971 | 128971 | 2020-05-09 | Niagara | New York | 36063 | 627 | 32 |
131960 | 131960 | 2020-05-10 | Niagara | New York | 36063 | 643 | 33 |
134951 | 134951 | 2020-05-11 | Niagara | New York | 36063 | 655 | 34 |
137941 | 137941 | 2020-05-12 | Niagara | New York | 36063 | 671 | 36 |
140937 | 140937 | 2020-05-13 | Niagara | New York | 36063 | 690 | 37 |
143932 | 143932 | 2020-05-14 | Niagara | New York | 36063 | 710 | 38 |
146933 | 146933 | 2020-05-15 | Niagara | New York | 36063 | 743 | 38 |
149940 | 149940 | 2020-05-16 | Niagara | New York | 36063 | 770 | 39 |
152950 | 152950 | 2020-05-17 | Niagara | New York | 36063 | 792 | 39 |
155967 | 155967 | 2020-05-18 | Niagara | New York | 36063 | 818 | 39 |
158985 | 158985 | 2020-05-19 | Niagara | New York | 36063 | 845 | 39 |
162012 | 162012 | 2020-05-20 | Niagara | New York | 36063 | 858 | 39 |
165041 | 165041 | 2020-05-21 | Niagara | New York | 36063 | 880 | 40 |
168076 | 168076 | 2020-05-22 | Niagara | New York | 36063 | 897 | 40 |
171115 | 171115 | 2020-05-23 | Niagara | New York | 36063 | 927 | 40 |
174157 | 174157 | 2020-05-24 | Niagara | New York | 36063 | 941 | 41 |
177201 | 177201 | 2020-05-25 | Niagara | New York | 36063 | 955 | 43 |
180244 | 180244 | 2020-05-26 | Niagara | New York | 36063 | 965 | 44 |
183292 | 183292 | 2020-05-27 | Niagara | New York | 36063 | 972 | 48 |
186349 | 186349 | 2020-05-28 | Niagara | New York | 36063 | 984 | 50 |
189409 | 189409 | 2020-05-29 | Niagara | New York | 36063 | 1008 | 50 |
192473 | 192473 | 2020-05-30 | Niagara | New York | 36063 | 1020 | 51 |
195543 | 195543 | 2020-05-31 | Niagara | New York | 36063 | 1037 | 51 |
198616 | 198616 | 2020-06-01 | Niagara | New York | 36063 | 1046 | 51 |
201690 | 201690 | 2020-06-02 | Niagara | New York | 36063 | 1048 | 53 |
204767 | 204767 | 2020-06-03 | Niagara | New York | 36063 | 1067 | 54 |
207848 | 207848 | 2020-06-04 | Niagara | New York | 36063 | 1085 | 54 |
210930 | 210930 | 2020-06-05 | Niagara | New York | 36063 | 1099 | 55 |
214014 | 214014 | 2020-06-06 | Niagara | New York | 36063 | 1109 | 55 |
217104 | 217104 | 2020-06-07 | Niagara | New York | 36063 | 1112 | 55 |
220196 | 220196 | 2020-06-08 | Niagara | New York | 36063 | 1116 | 57 |
223290 | 223290 | 2020-06-09 | Niagara | New York | 36063 | 1125 | 57 |
226390 | 226390 | 2020-06-10 | Niagara | New York | 36063 | 1129 | 59 |
229494 | 229494 | 2020-06-11 | Niagara | New York | 36063 | 1136 | 60 |
232599 | 232599 | 2020-06-12 | Niagara | New York | 36063 | 1143 | 60 |
235704 | 235704 | 2020-06-13 | Niagara | New York | 36063 | 1154 | 63 |
238812 | 238812 | 2020-06-14 | Niagara | New York | 36063 | 1166 | 63 |
241921 | 241921 | 2020-06-15 | Niagara | New York | 36063 | 1169 | 64 |
245033 | 245033 | 2020-06-16 | Niagara | New York | 36063 | 1171 | 64 |
248146 | 248146 | 2020-06-17 | Niagara | New York | 36063 | 1177 | 64 |
251261 | 251261 | 2020-06-18 | Niagara | New York | 36063 | 1183 | 65 |
254376 | 254376 | 2020-06-19 | Niagara | New York | 36063 | 1185 | 65 |
257499 | 257499 | 2020-06-20 | Niagara | New York | 36063 | 1188 | 65 |
260626 | 260626 | 2020-06-21 | Niagara | New York | 36063 | 1192 | 65 |
263754 | 263754 | 2020-06-22 | Niagara | New York | 36063 | 1193 | 65 |
266882 | 266882 | 2020-06-23 | Niagara | New York | 36063 | 1195 | 65 |
270016 | 270016 | 2020-06-24 | Niagara | New York | 36063 | 1199 | 66 |
273155 | 273155 | 2020-06-25 | Niagara | New York | 36063 | 1203 | 66 |
276301 | 276301 | 2020-06-26 | Niagara | New York | 36063 | 1213 | 66 |
279449 | 279449 | 2020-06-27 | Niagara | New York | 36063 | 1223 | 66 |
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);