ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Cleveland" and state = "Oklahoma" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
267162 | 267162 | 2020-06-23 | Cleveland | Oklahoma | 40027 | 711 | 40 |
270296 | 270296 | 2020-06-24 | Cleveland | Oklahoma | 40027 | 735 | 40 |
273435 | 273435 | 2020-06-25 | Cleveland | Oklahoma | 40027 | 763 | 40 |
276582 | 276582 | 2020-06-26 | Cleveland | Oklahoma | 40027 | 780 | 40 |
279730 | 279730 | 2020-06-27 | Cleveland | Oklahoma | 40027 | 795 | 40 |
282876 | 282876 | 2020-06-28 | Cleveland | Oklahoma | 40027 | 852 | 40 |
286021 | 286021 | 2020-06-29 | Cleveland | Oklahoma | 40027 | 873 | 40 |
289171 | 289171 | 2020-06-30 | Cleveland | Oklahoma | 40027 | 886 | 40 |
292323 | 292323 | 2020-07-01 | Cleveland | Oklahoma | 40027 | 911 | 40 |
295479 | 295479 | 2020-07-02 | Cleveland | Oklahoma | 40027 | 935 | 40 |
298638 | 298638 | 2020-07-03 | Cleveland | Oklahoma | 40027 | 1003 | 40 |
301801 | 301801 | 2020-07-04 | Cleveland | Oklahoma | 40027 | 1035 | 40 |
304964 | 304964 | 2020-07-05 | Cleveland | Oklahoma | 40027 | 1052 | 40 |
308131 | 308131 | 2020-07-06 | Cleveland | Oklahoma | 40027 | 1107 | 40 |
311300 | 311300 | 2020-07-07 | Cleveland | Oklahoma | 40027 | 1157 | 40 |
314472 | 314472 | 2020-07-08 | Cleveland | Oklahoma | 40027 | 1186 | 40 |
317645 | 317645 | 2020-07-09 | Cleveland | Oklahoma | 40027 | 1208 | 40 |
320822 | 320822 | 2020-07-10 | Cleveland | Oklahoma | 40027 | 1238 | 40 |
324002 | 324002 | 2020-07-11 | Cleveland | Oklahoma | 40027 | 1277 | 40 |
327187 | 327187 | 2020-07-12 | Cleveland | Oklahoma | 40027 | 1319 | 40 |
330374 | 330374 | 2020-07-13 | Cleveland | Oklahoma | 40027 | 1348 | 40 |
333566 | 333566 | 2020-07-14 | Cleveland | Oklahoma | 40027 | 1448 | 40 |
336760 | 336760 | 2020-07-15 | Cleveland | Oklahoma | 40027 | 1526 | 40 |
339956 | 339956 | 2020-07-16 | Cleveland | Oklahoma | 40027 | 1576 | 40 |
343154 | 343154 | 2020-07-17 | Cleveland | Oklahoma | 40027 | 1630 | 40 |
346354 | 346354 | 2020-07-18 | Cleveland | Oklahoma | 40027 | 1670 | 40 |
349554 | 349554 | 2020-07-19 | Cleveland | Oklahoma | 40027 | 1678 | 40 |
352757 | 352757 | 2020-07-20 | Cleveland | Oklahoma | 40027 | 1693 | 40 |
355960 | 355960 | 2020-07-21 | Cleveland | Oklahoma | 40027 | 1760 | 40 |
359164 | 359164 | 2020-07-22 | Cleveland | Oklahoma | 40027 | 1847 | 40 |
362370 | 362370 | 2020-07-23 | Cleveland | Oklahoma | 40027 | 1887 | 40 |
365576 | 365576 | 2020-07-24 | Cleveland | Oklahoma | 40027 | 1958 | 40 |
368785 | 368785 | 2020-07-25 | Cleveland | Oklahoma | 40027 | 2048 | 41 |
371997 | 371997 | 2020-07-26 | Cleveland | Oklahoma | 40027 | 2120 | 41 |
375209 | 375209 | 2020-07-27 | Cleveland | Oklahoma | 40027 | 2170 | 41 |
378426 | 378426 | 2020-07-28 | Cleveland | Oklahoma | 40027 | 2209 | 42 |
381643 | 381643 | 2020-07-29 | Cleveland | Oklahoma | 40027 | 2382 | 45 |
384861 | 384861 | 2020-07-30 | Cleveland | Oklahoma | 40027 | 2487 | 47 |
388078 | 388078 | 2020-07-31 | Cleveland | Oklahoma | 40027 | 2555 | 49 |
391295 | 391295 | 2020-08-01 | Cleveland | Oklahoma | 40027 | 2652 | 49 |
394511 | 394511 | 2020-08-02 | Cleveland | Oklahoma | 40027 | 2703 | 49 |
397728 | 397728 | 2020-08-03 | Cleveland | Oklahoma | 40027 | 2725 | 49 |
400943 | 400943 | 2020-08-04 | Cleveland | Oklahoma | 40027 | 2780 | 52 |
404161 | 404161 | 2020-08-05 | Cleveland | Oklahoma | 40027 | 2871 | 54 |
407380 | 407380 | 2020-08-06 | Cleveland | Oklahoma | 40027 | 2909 | 55 |
410600 | 410600 | 2020-08-07 | Cleveland | Oklahoma | 40027 | 2932 | 55 |
413820 | 413820 | 2020-08-08 | Cleveland | Oklahoma | 40027 | 2967 | 55 |
417041 | 417041 | 2020-08-09 | Cleveland | Oklahoma | 40027 | 2994 | 55 |
420261 | 420261 | 2020-08-10 | Cleveland | Oklahoma | 40027 | 3017 | 55 |
423484 | 423484 | 2020-08-11 | Cleveland | Oklahoma | 40027 | 3048 | 56 |
426707 | 426707 | 2020-08-12 | Cleveland | Oklahoma | 40027 | 3084 | 56 |
429932 | 429932 | 2020-08-13 | Cleveland | Oklahoma | 40027 | 3123 | 56 |
433158 | 433158 | 2020-08-14 | Cleveland | Oklahoma | 40027 | 3151 | 56 |
436384 | 436384 | 2020-08-15 | Cleveland | Oklahoma | 40027 | 3179 | 57 |
439609 | 439609 | 2020-08-16 | Cleveland | Oklahoma | 40027 | 3192 | 57 |
442836 | 442836 | 2020-08-17 | Cleveland | Oklahoma | 40027 | 3215 | 58 |
446062 | 446062 | 2020-08-18 | Cleveland | Oklahoma | 40027 | 3246 | 61 |
449290 | 449290 | 2020-08-19 | Cleveland | Oklahoma | 40027 | 3336 | 61 |
452518 | 452518 | 2020-08-20 | Cleveland | Oklahoma | 40027 | 3399 | 62 |
455746 | 455746 | 2020-08-21 | Cleveland | Oklahoma | 40027 | 3469 | 62 |
458974 | 458974 | 2020-08-22 | Cleveland | Oklahoma | 40027 | 3510 | 63 |
462202 | 462202 | 2020-08-23 | Cleveland | Oklahoma | 40027 | 3522 | 63 |
465431 | 465431 | 2020-08-24 | Cleveland | Oklahoma | 40027 | 3543 | 63 |
468659 | 468659 | 2020-08-25 | Cleveland | Oklahoma | 40027 | 3581 | 63 |
471891 | 471891 | 2020-08-26 | Cleveland | Oklahoma | 40027 | 3638 | 63 |
475125 | 475125 | 2020-08-27 | Cleveland | Oklahoma | 40027 | 3721 | 63 |
478358 | 478358 | 2020-08-28 | Cleveland | Oklahoma | 40027 | 3749 | 63 |
481592 | 481592 | 2020-08-29 | Cleveland | Oklahoma | 40027 | 3783 | 63 |
484827 | 484827 | 2020-08-30 | Cleveland | Oklahoma | 40027 | 3882 | 64 |
488060 | 488060 | 2020-08-31 | Cleveland | Oklahoma | 40027 | 3930 | 64 |
491293 | 491293 | 2020-09-01 | Cleveland | Oklahoma | 40027 | 3991 | 64 |
494527 | 494527 | 2020-09-02 | Cleveland | Oklahoma | 40027 | 4019 | 65 |
497760 | 497760 | 2020-09-03 | Cleveland | Oklahoma | 40027 | 4105 | 65 |
500994 | 500994 | 2020-09-04 | Cleveland | Oklahoma | 40027 | 4179 | 66 |
504228 | 504228 | 2020-09-05 | Cleveland | Oklahoma | 40027 | 4405 | 66 |
507460 | 507460 | 2020-09-06 | Cleveland | Oklahoma | 40027 | 4437 | 66 |
510693 | 510693 | 2020-09-07 | Cleveland | Oklahoma | 40027 | 4511 | 66 |
513926 | 513926 | 2020-09-08 | Cleveland | Oklahoma | 40027 | 4551 | 66 |
517161 | 517161 | 2020-09-09 | Cleveland | Oklahoma | 40027 | 4621 | 67 |
520397 | 520397 | 2020-09-10 | Cleveland | Oklahoma | 40027 | 4757 | 67 |
523633 | 523633 | 2020-09-11 | Cleveland | Oklahoma | 40027 | 4861 | 67 |
526869 | 526869 | 2020-09-12 | Cleveland | Oklahoma | 40027 | 4919 | 67 |
530106 | 530106 | 2020-09-13 | Cleveland | Oklahoma | 40027 | 4965 | 68 |
533341 | 533341 | 2020-09-14 | Cleveland | Oklahoma | 40027 | 5002 | 68 |
536577 | 536577 | 2020-09-15 | Cleveland | Oklahoma | 40027 | 5110 | 68 |
539814 | 539814 | 2020-09-16 | Cleveland | Oklahoma | 40027 | 5232 | 68 |
543050 | 543050 | 2020-09-17 | Cleveland | Oklahoma | 40027 | 5290 | 68 |
546287 | 546287 | 2020-09-18 | Cleveland | Oklahoma | 40027 | 5397 | 68 |
549526 | 549526 | 2020-09-19 | Cleveland | Oklahoma | 40027 | 5512 | 68 |
552765 | 552765 | 2020-09-20 | Cleveland | Oklahoma | 40027 | 5559 | 68 |
556002 | 556002 | 2020-09-21 | Cleveland | Oklahoma | 40027 | 5620 | 68 |
559239 | 559239 | 2020-09-22 | Cleveland | Oklahoma | 40027 | 5658 | 68 |
562476 | 562476 | 2020-09-23 | Cleveland | Oklahoma | 40027 | 5782 | 68 |
565717 | 565717 | 2020-09-24 | Cleveland | Oklahoma | 40027 | 5847 | 70 |
568958 | 568958 | 2020-09-25 | Cleveland | Oklahoma | 40027 | 5908 | 70 |
572200 | 572200 | 2020-09-26 | Cleveland | Oklahoma | 40027 | 5967 | 70 |
575444 | 575444 | 2020-09-27 | Cleveland | Oklahoma | 40027 | 6007 | 70 |
578685 | 578685 | 2020-09-28 | Cleveland | Oklahoma | 40027 | 6063 | 70 |
581925 | 581925 | 2020-09-29 | Cleveland | Oklahoma | 40027 | 6124 | 70 |
585165 | 585165 | 2020-09-30 | Cleveland | Oklahoma | 40027 | 6195 | 71 |
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);