ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 36065 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536291 | 536291 | 2020-09-15 | Oneida | New York | 36065 | 2356 | 120 |
533055 | 533055 | 2020-09-14 | Oneida | New York | 36065 | 2348 | 120 |
529820 | 529820 | 2020-09-13 | Oneida | New York | 36065 | 2347 | 120 |
526583 | 526583 | 2020-09-12 | Oneida | New York | 36065 | 2341 | 120 |
523347 | 523347 | 2020-09-11 | Oneida | New York | 36065 | 2333 | 120 |
520111 | 520111 | 2020-09-10 | Oneida | New York | 36065 | 2322 | 120 |
516875 | 516875 | 2020-09-09 | Oneida | New York | 36065 | 2316 | 120 |
513640 | 513640 | 2020-09-08 | Oneida | New York | 36065 | 2309 | 120 |
510407 | 510407 | 2020-09-07 | Oneida | New York | 36065 | 2305 | 120 |
507174 | 507174 | 2020-09-06 | Oneida | New York | 36065 | 2302 | 120 |
503942 | 503942 | 2020-09-05 | Oneida | New York | 36065 | 2298 | 120 |
500708 | 500708 | 2020-09-04 | Oneida | New York | 36065 | 2295 | 120 |
497474 | 497474 | 2020-09-03 | Oneida | New York | 36065 | 2286 | 120 |
494241 | 494241 | 2020-09-02 | Oneida | New York | 36065 | 2283 | 120 |
491007 | 491007 | 2020-09-01 | Oneida | New York | 36065 | 2281 | 120 |
487774 | 487774 | 2020-08-31 | Oneida | New York | 36065 | 2274 | 120 |
484541 | 484541 | 2020-08-30 | Oneida | New York | 36065 | 2272 | 120 |
481306 | 481306 | 2020-08-29 | Oneida | New York | 36065 | 2268 | 120 |
478073 | 478073 | 2020-08-28 | Oneida | New York | 36065 | 2265 | 120 |
474840 | 474840 | 2020-08-27 | Oneida | New York | 36065 | 2264 | 120 |
471606 | 471606 | 2020-08-26 | Oneida | New York | 36065 | 2259 | 120 |
468374 | 468374 | 2020-08-25 | Oneida | New York | 36065 | 2256 | 120 |
465146 | 465146 | 2020-08-24 | Oneida | New York | 36065 | 2245 | 120 |
461917 | 461917 | 2020-08-23 | Oneida | New York | 36065 | 2244 | 118 |
458689 | 458689 | 2020-08-22 | Oneida | New York | 36065 | 2242 | 117 |
455461 | 455461 | 2020-08-21 | Oneida | New York | 36065 | 2233 | 117 |
452233 | 452233 | 2020-08-20 | Oneida | New York | 36065 | 2222 | 117 |
449005 | 449005 | 2020-08-19 | Oneida | New York | 36065 | 2218 | 117 |
445777 | 445777 | 2020-08-18 | Oneida | New York | 36065 | 2213 | 117 |
442551 | 442551 | 2020-08-17 | Oneida | New York | 36065 | 2201 | 117 |
439324 | 439324 | 2020-08-16 | Oneida | New York | 36065 | 2198 | 117 |
436099 | 436099 | 2020-08-15 | Oneida | New York | 36065 | 2195 | 117 |
432873 | 432873 | 2020-08-14 | Oneida | New York | 36065 | 2189 | 117 |
429647 | 429647 | 2020-08-13 | Oneida | New York | 36065 | 2183 | 116 |
426422 | 426422 | 2020-08-12 | Oneida | New York | 36065 | 2180 | 115 |
423199 | 423199 | 2020-08-11 | Oneida | New York | 36065 | 2175 | 115 |
419976 | 419976 | 2020-08-10 | Oneida | New York | 36065 | 2150 | 115 |
416756 | 416756 | 2020-08-09 | Oneida | New York | 36065 | 2146 | 115 |
413535 | 413535 | 2020-08-08 | Oneida | New York | 36065 | 2142 | 115 |
410315 | 410315 | 2020-08-07 | Oneida | New York | 36065 | 2129 | 115 |
407095 | 407095 | 2020-08-06 | Oneida | New York | 36065 | 2117 | 115 |
403876 | 403876 | 2020-08-05 | Oneida | New York | 36065 | 2114 | 110 |
400658 | 400658 | 2020-08-04 | Oneida | New York | 36065 | 2103 | 110 |
397443 | 397443 | 2020-08-03 | Oneida | New York | 36065 | 2090 | 110 |
394226 | 394226 | 2020-08-02 | Oneida | New York | 36065 | 2087 | 110 |
391010 | 391010 | 2020-08-01 | Oneida | New York | 36065 | 2081 | 110 |
387793 | 387793 | 2020-07-31 | Oneida | New York | 36065 | 2070 | 110 |
384576 | 384576 | 2020-07-30 | Oneida | New York | 36065 | 2062 | 110 |
381358 | 381358 | 2020-07-29 | Oneida | New York | 36065 | 2053 | 110 |
378141 | 378141 | 2020-07-28 | Oneida | New York | 36065 | 2028 | 110 |
374925 | 374925 | 2020-07-27 | Oneida | New York | 36065 | 2010 | 109 |
371713 | 371713 | 2020-07-26 | Oneida | New York | 36065 | 2000 | 109 |
368501 | 368501 | 2020-07-25 | Oneida | New York | 36065 | 2000 | 109 |
365292 | 365292 | 2020-07-24 | Oneida | New York | 36065 | 1990 | 109 |
362086 | 362086 | 2020-07-23 | Oneida | New York | 36065 | 1980 | 108 |
358880 | 358880 | 2020-07-22 | Oneida | New York | 36065 | 1975 | 108 |
355676 | 355676 | 2020-07-21 | Oneida | New York | 36065 | 1962 | 108 |
352473 | 352473 | 2020-07-20 | Oneida | New York | 36065 | 1942 | 108 |
349270 | 349270 | 2020-07-19 | Oneida | New York | 36065 | 1940 | 107 |
346069 | 346069 | 2020-07-18 | Oneida | New York | 36065 | 1937 | 107 |
342870 | 342870 | 2020-07-17 | Oneida | New York | 36065 | 1909 | 105 |
339672 | 339672 | 2020-07-16 | Oneida | New York | 36065 | 1868 | 104 |
336476 | 336476 | 2020-07-15 | Oneida | New York | 36065 | 1860 | 104 |
333282 | 333282 | 2020-07-14 | Oneida | New York | 36065 | 1847 | 104 |
330092 | 330092 | 2020-07-13 | Oneida | New York | 36065 | 1830 | 104 |
326905 | 326905 | 2020-07-12 | Oneida | New York | 36065 | 1823 | 101 |
323721 | 323721 | 2020-07-11 | Oneida | New York | 36065 | 1818 | 100 |
320541 | 320541 | 2020-07-10 | Oneida | New York | 36065 | 1806 | 100 |
317364 | 317364 | 2020-07-09 | Oneida | New York | 36065 | 1791 | 100 |
314190 | 314190 | 2020-07-08 | Oneida | New York | 36065 | 1776 | 99 |
311019 | 311019 | 2020-07-07 | Oneida | New York | 36065 | 1760 | 98 |
307851 | 307851 | 2020-07-06 | Oneida | New York | 36065 | 1749 | 98 |
304684 | 304684 | 2020-07-05 | Oneida | New York | 36065 | 1742 | 98 |
301521 | 301521 | 2020-07-04 | Oneida | New York | 36065 | 1725 | 97 |
298358 | 298358 | 2020-07-03 | Oneida | New York | 36065 | 1708 | 96 |
295198 | 295198 | 2020-07-02 | Oneida | New York | 36065 | 1672 | 93 |
292043 | 292043 | 2020-07-01 | Oneida | New York | 36065 | 1642 | 93 |
288891 | 288891 | 2020-06-30 | Oneida | New York | 36065 | 1627 | 92 |
285741 | 285741 | 2020-06-29 | Oneida | New York | 36065 | 1616 | 92 |
282596 | 282596 | 2020-06-28 | Oneida | New York | 36065 | 1586 | 92 |
279450 | 279450 | 2020-06-27 | Oneida | New York | 36065 | 1547 | 92 |
276302 | 276302 | 2020-06-26 | Oneida | New York | 36065 | 1520 | 92 |
273156 | 273156 | 2020-06-25 | Oneida | New York | 36065 | 1479 | 90 |
270017 | 270017 | 2020-06-24 | Oneida | New York | 36065 | 1445 | 90 |
266883 | 266883 | 2020-06-23 | Oneida | New York | 36065 | 1421 | 89 |
263755 | 263755 | 2020-06-22 | Oneida | New York | 36065 | 1416 | 87 |
260627 | 260627 | 2020-06-21 | Oneida | New York | 36065 | 1393 | 87 |
257500 | 257500 | 2020-06-20 | Oneida | New York | 36065 | 1378 | 87 |
254377 | 254377 | 2020-06-19 | Oneida | New York | 36065 | 1357 | 86 |
251262 | 251262 | 2020-06-18 | Oneida | New York | 36065 | 1332 | 83 |
248147 | 248147 | 2020-06-17 | Oneida | New York | 36065 | 1307 | 83 |
245034 | 245034 | 2020-06-16 | Oneida | New York | 36065 | 1301 | 81 |
241922 | 241922 | 2020-06-15 | Oneida | New York | 36065 | 1280 | 80 |
238813 | 238813 | 2020-06-14 | Oneida | New York | 36065 | 1273 | 80 |
235705 | 235705 | 2020-06-13 | Oneida | New York | 36065 | 1253 | 78 |
232600 | 232600 | 2020-06-12 | Oneida | New York | 36065 | 1237 | 75 |
229495 | 229495 | 2020-06-11 | Oneida | New York | 36065 | 1216 | 72 |
226391 | 226391 | 2020-06-10 | Oneida | New York | 36065 | 1203 | 70 |
223291 | 223291 | 2020-06-09 | Oneida | New York | 36065 | 1185 | 69 |
220197 | 220197 | 2020-06-08 | Oneida | New York | 36065 | 1170 | 67 |
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);