ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 36021 and state = "New York" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5714 | 5714 | 2020-03-20 | Columbia | New York | 36021 | 1 | 0 |
6708 | 6708 | 2020-03-21 | Columbia | New York | 36021 | 2 | 0 |
7801 | 7801 | 2020-03-22 | Columbia | New York | 36021 | 5 | 0 |
8999 | 8999 | 2020-03-23 | Columbia | New York | 36021 | 10 | 0 |
10306 | 10306 | 2020-03-24 | Columbia | New York | 36021 | 11 | 0 |
11741 | 11741 | 2020-03-25 | Columbia | New York | 36021 | 12 | 0 |
13344 | 13344 | 2020-03-26 | Columbia | New York | 36021 | 13 | 0 |
15078 | 15078 | 2020-03-27 | Columbia | New York | 36021 | 20 | 0 |
16908 | 16908 | 2020-03-28 | Columbia | New York | 36021 | 22 | 0 |
18832 | 18832 | 2020-03-29 | Columbia | New York | 36021 | 23 | 1 |
20871 | 20871 | 2020-03-30 | Columbia | New York | 36021 | 26 | 1 |
22994 | 22994 | 2020-03-31 | Columbia | New York | 36021 | 36 | 1 |
25188 | 25188 | 2020-04-01 | Columbia | New York | 36021 | 41 | 1 |
27448 | 27448 | 2020-04-02 | Columbia | New York | 36021 | 41 | 2 |
29772 | 29772 | 2020-04-03 | Columbia | New York | 36021 | 41 | 2 |
32158 | 32158 | 2020-04-04 | Columbia | New York | 36021 | 61 | 3 |
34589 | 34589 | 2020-04-05 | Columbia | New York | 36021 | 61 | 3 |
37059 | 37059 | 2020-04-06 | Columbia | New York | 36021 | 70 | 3 |
39574 | 39574 | 2020-04-07 | Columbia | New York | 36021 | 72 | 3 |
42131 | 42131 | 2020-04-08 | Columbia | New York | 36021 | 72 | 4 |
44714 | 44714 | 2020-04-09 | Columbia | New York | 36021 | 70 | 4 |
47327 | 47327 | 2020-04-10 | Columbia | New York | 36021 | 74 | 4 |
49982 | 49982 | 2020-04-11 | Columbia | New York | 36021 | 77 | 6 |
52655 | 52655 | 2020-04-12 | Columbia | New York | 36021 | 79 | 8 |
55338 | 55338 | 2020-04-13 | Columbia | New York | 36021 | 80 | 9 |
58038 | 58038 | 2020-04-14 | Columbia | New York | 36021 | 84 | 10 |
60752 | 60752 | 2020-04-15 | Columbia | New York | 36021 | 96 | 11 |
63478 | 63478 | 2020-04-16 | Columbia | New York | 36021 | 99 | 13 |
66220 | 66220 | 2020-04-17 | Columbia | New York | 36021 | 101 | 13 |
68977 | 68977 | 2020-04-18 | Columbia | New York | 36021 | 105 | 13 |
71744 | 71744 | 2020-04-19 | Columbia | New York | 36021 | 107 | 15 |
74519 | 74519 | 2020-04-20 | Columbia | New York | 36021 | 111 | 15 |
77300 | 77300 | 2020-04-21 | Columbia | New York | 36021 | 113 | 16 |
80089 | 80089 | 2020-04-22 | Columbia | New York | 36021 | 117 | 16 |
82888 | 82888 | 2020-04-23 | Columbia | New York | 36021 | 123 | 16 |
85692 | 85692 | 2020-04-24 | Columbia | New York | 36021 | 129 | 16 |
88504 | 88504 | 2020-04-25 | Columbia | New York | 36021 | 140 | 16 |
91319 | 91319 | 2020-04-26 | Columbia | New York | 36021 | 143 | 16 |
94144 | 94144 | 2020-04-27 | Columbia | New York | 36021 | 146 | 16 |
96980 | 96980 | 2020-04-28 | Columbia | New York | 36021 | 154 | 16 |
99827 | 99827 | 2020-04-29 | Columbia | New York | 36021 | 165 | 16 |
102680 | 102680 | 2020-04-30 | Columbia | New York | 36021 | 170 | 16 |
105542 | 105542 | 2020-05-01 | Columbia | New York | 36021 | 202 | 16 |
108409 | 108409 | 2020-05-02 | Columbia | New York | 36021 | 205 | 16 |
111282 | 111282 | 2020-05-03 | Columbia | New York | 36021 | 209 | 17 |
114163 | 114163 | 2020-05-04 | Columbia | New York | 36021 | 213 | 17 |
117043 | 117043 | 2020-05-05 | Columbia | New York | 36021 | 229 | 18 |
120004 | 120004 | 2020-05-06 | Columbia | New York | 36021 | 291 | 21 |
122979 | 122979 | 2020-05-07 | Columbia | New York | 36021 | 302 | 21 |
125962 | 125962 | 2020-05-08 | Columbia | New York | 36021 | 304 | 21 |
128951 | 128951 | 2020-05-09 | Columbia | New York | 36021 | 304 | 23 |
131940 | 131940 | 2020-05-10 | Columbia | New York | 36021 | 312 | 23 |
134931 | 134931 | 2020-05-11 | Columbia | New York | 36021 | 314 | 23 |
137921 | 137921 | 2020-05-12 | Columbia | New York | 36021 | 314 | 26 |
140917 | 140917 | 2020-05-13 | Columbia | New York | 36021 | 318 | 29 |
143912 | 143912 | 2020-05-14 | Columbia | New York | 36021 | 327 | 30 |
146913 | 146913 | 2020-05-15 | Columbia | New York | 36021 | 333 | 30 |
149920 | 149920 | 2020-05-16 | Columbia | New York | 36021 | 338 | 30 |
152930 | 152930 | 2020-05-17 | Columbia | New York | 36021 | 340 | 30 |
155947 | 155947 | 2020-05-18 | Columbia | New York | 36021 | 346 | 31 |
158965 | 158965 | 2020-05-19 | Columbia | New York | 36021 | 350 | 32 |
161992 | 161992 | 2020-05-20 | Columbia | New York | 36021 | 350 | 32 |
165021 | 165021 | 2020-05-21 | Columbia | New York | 36021 | 355 | 34 |
168056 | 168056 | 2020-05-22 | Columbia | New York | 36021 | 356 | 34 |
171095 | 171095 | 2020-05-23 | Columbia | New York | 36021 | 359 | 35 |
174137 | 174137 | 2020-05-24 | Columbia | New York | 36021 | 365 | 36 |
177181 | 177181 | 2020-05-25 | Columbia | New York | 36021 | 372 | 36 |
180224 | 180224 | 2020-05-26 | Columbia | New York | 36021 | 373 | 36 |
183272 | 183272 | 2020-05-27 | Columbia | New York | 36021 | 380 | 37 |
186329 | 186329 | 2020-05-28 | Columbia | New York | 36021 | 380 | 37 |
189389 | 189389 | 2020-05-29 | Columbia | New York | 36021 | 382 | 37 |
192453 | 192453 | 2020-05-30 | Columbia | New York | 36021 | 383 | 37 |
195523 | 195523 | 2020-05-31 | Columbia | New York | 36021 | 387 | 38 |
198596 | 198596 | 2020-06-01 | Columbia | New York | 36021 | 389 | 38 |
201670 | 201670 | 2020-06-02 | Columbia | New York | 36021 | 391 | 38 |
204747 | 204747 | 2020-06-03 | Columbia | New York | 36021 | 399 | 38 |
207828 | 207828 | 2020-06-04 | Columbia | New York | 36021 | 400 | 39 |
210910 | 210910 | 2020-06-05 | Columbia | New York | 36021 | 411 | 39 |
213994 | 213994 | 2020-06-06 | Columbia | New York | 36021 | 412 | 39 |
217084 | 217084 | 2020-06-07 | Columbia | New York | 36021 | 414 | 39 |
220176 | 220176 | 2020-06-08 | Columbia | New York | 36021 | 414 | 39 |
223270 | 223270 | 2020-06-09 | Columbia | New York | 36021 | 414 | 40 |
226370 | 226370 | 2020-06-10 | Columbia | New York | 36021 | 420 | 41 |
229474 | 229474 | 2020-06-11 | Columbia | New York | 36021 | 424 | 41 |
232579 | 232579 | 2020-06-12 | Columbia | New York | 36021 | 428 | 42 |
235684 | 235684 | 2020-06-13 | Columbia | New York | 36021 | 431 | 42 |
238792 | 238792 | 2020-06-14 | Columbia | New York | 36021 | 436 | 42 |
241901 | 241901 | 2020-06-15 | Columbia | New York | 36021 | 439 | 42 |
245013 | 245013 | 2020-06-16 | Columbia | New York | 36021 | 442 | 43 |
248126 | 248126 | 2020-06-17 | Columbia | New York | 36021 | 442 | 43 |
251241 | 251241 | 2020-06-18 | Columbia | New York | 36021 | 443 | 43 |
254356 | 254356 | 2020-06-19 | Columbia | New York | 36021 | 446 | 43 |
257479 | 257479 | 2020-06-20 | Columbia | New York | 36021 | 451 | 43 |
260606 | 260606 | 2020-06-21 | Columbia | New York | 36021 | 451 | 43 |
263734 | 263734 | 2020-06-22 | Columbia | New York | 36021 | 452 | 43 |
266862 | 266862 | 2020-06-23 | Columbia | New York | 36021 | 454 | 43 |
269996 | 269996 | 2020-06-24 | Columbia | New York | 36021 | 454 | 43 |
273135 | 273135 | 2020-06-25 | Columbia | New York | 36021 | 455 | 43 |
276281 | 276281 | 2020-06-26 | Columbia | New York | 36021 | 460 | 43 |
279429 | 279429 | 2020-06-27 | Columbia | New York | 36021 | 461 | 43 |
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);