ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36069 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 |
---|---|---|---|---|---|---|---|
536293 | 536293 | 2020-09-15 | Ontario | New York | 36069 | 444 | 28 |
533057 | 533057 | 2020-09-14 | Ontario | New York | 36069 | 443 | 28 |
529822 | 529822 | 2020-09-13 | Ontario | New York | 36069 | 439 | 28 |
526585 | 526585 | 2020-09-12 | Ontario | New York | 36069 | 435 | 28 |
523349 | 523349 | 2020-09-11 | Ontario | New York | 36069 | 427 | 28 |
520113 | 520113 | 2020-09-10 | Ontario | New York | 36069 | 423 | 28 |
516877 | 516877 | 2020-09-09 | Ontario | New York | 36069 | 421 | 28 |
513642 | 513642 | 2020-09-08 | Ontario | New York | 36069 | 413 | 28 |
510409 | 510409 | 2020-09-07 | Ontario | New York | 36069 | 408 | 28 |
507176 | 507176 | 2020-09-06 | Ontario | New York | 36069 | 405 | 28 |
503944 | 503944 | 2020-09-05 | Ontario | New York | 36069 | 401 | 28 |
500710 | 500710 | 2020-09-04 | Ontario | New York | 36069 | 398 | 28 |
497476 | 497476 | 2020-09-03 | Ontario | New York | 36069 | 396 | 28 |
494243 | 494243 | 2020-09-02 | Ontario | New York | 36069 | 393 | 28 |
491009 | 491009 | 2020-09-01 | Ontario | New York | 36069 | 393 | 28 |
487776 | 487776 | 2020-08-31 | Ontario | New York | 36069 | 391 | 28 |
484543 | 484543 | 2020-08-30 | Ontario | New York | 36069 | 389 | 28 |
481308 | 481308 | 2020-08-29 | Ontario | New York | 36069 | 386 | 28 |
478075 | 478075 | 2020-08-28 | Ontario | New York | 36069 | 385 | 28 |
474842 | 474842 | 2020-08-27 | Ontario | New York | 36069 | 384 | 28 |
471608 | 471608 | 2020-08-26 | Ontario | New York | 36069 | 381 | 28 |
468376 | 468376 | 2020-08-25 | Ontario | New York | 36069 | 381 | 28 |
465148 | 465148 | 2020-08-24 | Ontario | New York | 36069 | 381 | 28 |
461919 | 461919 | 2020-08-23 | Ontario | New York | 36069 | 381 | 28 |
458691 | 458691 | 2020-08-22 | Ontario | New York | 36069 | 378 | 28 |
455463 | 455463 | 2020-08-21 | Ontario | New York | 36069 | 373 | 28 |
452235 | 452235 | 2020-08-20 | Ontario | New York | 36069 | 373 | 28 |
449007 | 449007 | 2020-08-19 | Ontario | New York | 36069 | 371 | 28 |
445779 | 445779 | 2020-08-18 | Ontario | New York | 36069 | 371 | 28 |
442553 | 442553 | 2020-08-17 | Ontario | New York | 36069 | 369 | 28 |
439326 | 439326 | 2020-08-16 | Ontario | New York | 36069 | 368 | 28 |
436101 | 436101 | 2020-08-15 | Ontario | New York | 36069 | 367 | 27 |
432875 | 432875 | 2020-08-14 | Ontario | New York | 36069 | 366 | 27 |
429649 | 429649 | 2020-08-13 | Ontario | New York | 36069 | 365 | 27 |
426424 | 426424 | 2020-08-12 | Ontario | New York | 36069 | 363 | 27 |
423201 | 423201 | 2020-08-11 | Ontario | New York | 36069 | 362 | 27 |
419978 | 419978 | 2020-08-10 | Ontario | New York | 36069 | 361 | 27 |
416758 | 416758 | 2020-08-09 | Ontario | New York | 36069 | 360 | 27 |
413537 | 413537 | 2020-08-08 | Ontario | New York | 36069 | 357 | 27 |
410317 | 410317 | 2020-08-07 | Ontario | New York | 36069 | 357 | 27 |
407097 | 407097 | 2020-08-06 | Ontario | New York | 36069 | 355 | 27 |
403878 | 403878 | 2020-08-05 | Ontario | New York | 36069 | 352 | 26 |
400660 | 400660 | 2020-08-04 | Ontario | New York | 36069 | 352 | 26 |
397445 | 397445 | 2020-08-03 | Ontario | New York | 36069 | 351 | 26 |
394228 | 394228 | 2020-08-02 | Ontario | New York | 36069 | 349 | 26 |
391012 | 391012 | 2020-08-01 | Ontario | New York | 36069 | 349 | 26 |
387795 | 387795 | 2020-07-31 | Ontario | New York | 36069 | 349 | 26 |
384578 | 384578 | 2020-07-30 | Ontario | New York | 36069 | 349 | 26 |
381360 | 381360 | 2020-07-29 | Ontario | New York | 36069 | 347 | 26 |
378143 | 378143 | 2020-07-28 | Ontario | New York | 36069 | 345 | 26 |
374927 | 374927 | 2020-07-27 | Ontario | New York | 36069 | 343 | 26 |
371715 | 371715 | 2020-07-26 | Ontario | New York | 36069 | 341 | 26 |
368503 | 368503 | 2020-07-25 | Ontario | New York | 36069 | 338 | 26 |
365294 | 365294 | 2020-07-24 | Ontario | New York | 36069 | 337 | 26 |
362088 | 362088 | 2020-07-23 | Ontario | New York | 36069 | 334 | 26 |
358882 | 358882 | 2020-07-22 | Ontario | New York | 36069 | 333 | 26 |
355678 | 355678 | 2020-07-21 | Ontario | New York | 36069 | 329 | 26 |
352475 | 352475 | 2020-07-20 | Ontario | New York | 36069 | 326 | 26 |
349272 | 349272 | 2020-07-19 | Ontario | New York | 36069 | 324 | 26 |
346071 | 346071 | 2020-07-18 | Ontario | New York | 36069 | 324 | 26 |
342872 | 342872 | 2020-07-17 | Ontario | New York | 36069 | 319 | 26 |
339674 | 339674 | 2020-07-16 | Ontario | New York | 36069 | 317 | 26 |
336478 | 336478 | 2020-07-15 | Ontario | New York | 36069 | 312 | 26 |
333284 | 333284 | 2020-07-14 | Ontario | New York | 36069 | 307 | 25 |
330094 | 330094 | 2020-07-13 | Ontario | New York | 36069 | 302 | 25 |
326907 | 326907 | 2020-07-12 | Ontario | New York | 36069 | 300 | 25 |
323723 | 323723 | 2020-07-11 | Ontario | New York | 36069 | 296 | 25 |
320543 | 320543 | 2020-07-10 | Ontario | New York | 36069 | 293 | 25 |
317366 | 317366 | 2020-07-09 | Ontario | New York | 36069 | 290 | 25 |
314192 | 314192 | 2020-07-08 | Ontario | New York | 36069 | 286 | 25 |
311021 | 311021 | 2020-07-07 | Ontario | New York | 36069 | 283 | 25 |
307853 | 307853 | 2020-07-06 | Ontario | New York | 36069 | 282 | 25 |
304686 | 304686 | 2020-07-05 | Ontario | New York | 36069 | 280 | 25 |
301523 | 301523 | 2020-07-04 | Ontario | New York | 36069 | 278 | 25 |
298360 | 298360 | 2020-07-03 | Ontario | New York | 36069 | 275 | 25 |
295200 | 295200 | 2020-07-02 | Ontario | New York | 36069 | 268 | 25 |
292045 | 292045 | 2020-07-01 | Ontario | New York | 36069 | 265 | 25 |
288893 | 288893 | 2020-06-30 | Ontario | New York | 36069 | 259 | 25 |
285743 | 285743 | 2020-06-29 | Ontario | New York | 36069 | 257 | 25 |
282598 | 282598 | 2020-06-28 | Ontario | New York | 36069 | 256 | 25 |
279452 | 279452 | 2020-06-27 | Ontario | New York | 36069 | 254 | 25 |
276304 | 276304 | 2020-06-26 | Ontario | New York | 36069 | 252 | 25 |
273158 | 273158 | 2020-06-25 | Ontario | New York | 36069 | 248 | 25 |
270019 | 270019 | 2020-06-24 | Ontario | New York | 36069 | 246 | 25 |
266885 | 266885 | 2020-06-23 | Ontario | New York | 36069 | 242 | 25 |
263757 | 263757 | 2020-06-22 | Ontario | New York | 36069 | 242 | 25 |
260629 | 260629 | 2020-06-21 | Ontario | New York | 36069 | 240 | 24 |
257502 | 257502 | 2020-06-20 | Ontario | New York | 36069 | 239 | 23 |
254379 | 254379 | 2020-06-19 | Ontario | New York | 36069 | 239 | 22 |
251264 | 251264 | 2020-06-18 | Ontario | New York | 36069 | 235 | 22 |
248149 | 248149 | 2020-06-17 | Ontario | New York | 36069 | 234 | 22 |
245036 | 245036 | 2020-06-16 | Ontario | New York | 36069 | 234 | 22 |
241924 | 241924 | 2020-06-15 | Ontario | New York | 36069 | 233 | 22 |
238815 | 238815 | 2020-06-14 | Ontario | New York | 36069 | 233 | 22 |
235707 | 235707 | 2020-06-13 | Ontario | New York | 36069 | 230 | 22 |
232602 | 232602 | 2020-06-12 | Ontario | New York | 36069 | 230 | 22 |
229497 | 229497 | 2020-06-11 | Ontario | New York | 36069 | 229 | 22 |
226393 | 226393 | 2020-06-10 | Ontario | New York | 36069 | 222 | 22 |
223293 | 223293 | 2020-06-09 | Ontario | New York | 36069 | 222 | 22 |
220199 | 220199 | 2020-06-08 | Ontario | New York | 36069 | 221 | 22 |
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);