ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Canadian" and state = "Oklahoma" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
270291 | 270291 | 2020-06-24 | Canadian | Oklahoma | 40017 | 218 | 3 |
273430 | 273430 | 2020-06-25 | Canadian | Oklahoma | 40017 | 227 | 3 |
276577 | 276577 | 2020-06-26 | Canadian | Oklahoma | 40017 | 238 | 3 |
279725 | 279725 | 2020-06-27 | Canadian | Oklahoma | 40017 | 249 | 3 |
282871 | 282871 | 2020-06-28 | Canadian | Oklahoma | 40017 | 258 | 3 |
286016 | 286016 | 2020-06-29 | Canadian | Oklahoma | 40017 | 266 | 3 |
289166 | 289166 | 2020-06-30 | Canadian | Oklahoma | 40017 | 280 | 3 |
292318 | 292318 | 2020-07-01 | Canadian | Oklahoma | 40017 | 289 | 3 |
295474 | 295474 | 2020-07-02 | Canadian | Oklahoma | 40017 | 293 | 3 |
298633 | 298633 | 2020-07-03 | Canadian | Oklahoma | 40017 | 307 | 3 |
301796 | 301796 | 2020-07-04 | Canadian | Oklahoma | 40017 | 325 | 3 |
304959 | 304959 | 2020-07-05 | Canadian | Oklahoma | 40017 | 337 | 3 |
308126 | 308126 | 2020-07-06 | Canadian | Oklahoma | 40017 | 360 | 3 |
311295 | 311295 | 2020-07-07 | Canadian | Oklahoma | 40017 | 387 | 3 |
314467 | 314467 | 2020-07-08 | Canadian | Oklahoma | 40017 | 409 | 3 |
317640 | 317640 | 2020-07-09 | Canadian | Oklahoma | 40017 | 430 | 3 |
320817 | 320817 | 2020-07-10 | Canadian | Oklahoma | 40017 | 456 | 3 |
323997 | 323997 | 2020-07-11 | Canadian | Oklahoma | 40017 | 479 | 3 |
327182 | 327182 | 2020-07-12 | Canadian | Oklahoma | 40017 | 502 | 3 |
330369 | 330369 | 2020-07-13 | Canadian | Oklahoma | 40017 | 519 | 3 |
333561 | 333561 | 2020-07-14 | Canadian | Oklahoma | 40017 | 543 | 3 |
336755 | 336755 | 2020-07-15 | Canadian | Oklahoma | 40017 | 594 | 3 |
339951 | 339951 | 2020-07-16 | Canadian | Oklahoma | 40017 | 608 | 3 |
343149 | 343149 | 2020-07-17 | Canadian | Oklahoma | 40017 | 631 | 3 |
346349 | 346349 | 2020-07-18 | Canadian | Oklahoma | 40017 | 652 | 4 |
349549 | 349549 | 2020-07-19 | Canadian | Oklahoma | 40017 | 667 | 4 |
352752 | 352752 | 2020-07-20 | Canadian | Oklahoma | 40017 | 674 | 4 |
355955 | 355955 | 2020-07-21 | Canadian | Oklahoma | 40017 | 686 | 4 |
359159 | 359159 | 2020-07-22 | Canadian | Oklahoma | 40017 | 717 | 4 |
362365 | 362365 | 2020-07-23 | Canadian | Oklahoma | 40017 | 744 | 4 |
365571 | 365571 | 2020-07-24 | Canadian | Oklahoma | 40017 | 786 | 4 |
368780 | 368780 | 2020-07-25 | Canadian | Oklahoma | 40017 | 795 | 4 |
371992 | 371992 | 2020-07-26 | Canadian | Oklahoma | 40017 | 830 | 4 |
375204 | 375204 | 2020-07-27 | Canadian | Oklahoma | 40017 | 877 | 4 |
378421 | 378421 | 2020-07-28 | Canadian | Oklahoma | 40017 | 913 | 5 |
381638 | 381638 | 2020-07-29 | Canadian | Oklahoma | 40017 | 941 | 5 |
384856 | 384856 | 2020-07-30 | Canadian | Oklahoma | 40017 | 988 | 5 |
388073 | 388073 | 2020-07-31 | Canadian | Oklahoma | 40017 | 1009 | 5 |
391290 | 391290 | 2020-08-01 | Canadian | Oklahoma | 40017 | 1059 | 5 |
394506 | 394506 | 2020-08-02 | Canadian | Oklahoma | 40017 | 1078 | 5 |
397723 | 397723 | 2020-08-03 | Canadian | Oklahoma | 40017 | 1089 | 5 |
400938 | 400938 | 2020-08-04 | Canadian | Oklahoma | 40017 | 1106 | 6 |
404156 | 404156 | 2020-08-05 | Canadian | Oklahoma | 40017 | 1128 | 6 |
407375 | 407375 | 2020-08-06 | Canadian | Oklahoma | 40017 | 1152 | 7 |
410595 | 410595 | 2020-08-07 | Canadian | Oklahoma | 40017 | 1174 | 7 |
413815 | 413815 | 2020-08-08 | Canadian | Oklahoma | 40017 | 1194 | 7 |
417036 | 417036 | 2020-08-09 | Canadian | Oklahoma | 40017 | 1208 | 7 |
420256 | 420256 | 2020-08-10 | Canadian | Oklahoma | 40017 | 1224 | 7 |
423479 | 423479 | 2020-08-11 | Canadian | Oklahoma | 40017 | 1238 | 9 |
426702 | 426702 | 2020-08-12 | Canadian | Oklahoma | 40017 | 1256 | 9 |
429927 | 429927 | 2020-08-13 | Canadian | Oklahoma | 40017 | 1275 | 9 |
433153 | 433153 | 2020-08-14 | Canadian | Oklahoma | 40017 | 1298 | 9 |
436379 | 436379 | 2020-08-15 | Canadian | Oklahoma | 40017 | 1314 | 9 |
439604 | 439604 | 2020-08-16 | Canadian | Oklahoma | 40017 | 1331 | 9 |
442831 | 442831 | 2020-08-17 | Canadian | Oklahoma | 40017 | 1339 | 9 |
446057 | 446057 | 2020-08-18 | Canadian | Oklahoma | 40017 | 1343 | 9 |
449285 | 449285 | 2020-08-19 | Canadian | Oklahoma | 40017 | 1347 | 9 |
452513 | 452513 | 2020-08-20 | Canadian | Oklahoma | 40017 | 1361 | 9 |
455741 | 455741 | 2020-08-21 | Canadian | Oklahoma | 40017 | 1393 | 9 |
458969 | 458969 | 2020-08-22 | Canadian | Oklahoma | 40017 | 1409 | 9 |
462197 | 462197 | 2020-08-23 | Canadian | Oklahoma | 40017 | 1413 | 9 |
465426 | 465426 | 2020-08-24 | Canadian | Oklahoma | 40017 | 1420 | 9 |
468654 | 468654 | 2020-08-25 | Canadian | Oklahoma | 40017 | 1433 | 11 |
471886 | 471886 | 2020-08-26 | Canadian | Oklahoma | 40017 | 1455 | 11 |
475120 | 475120 | 2020-08-27 | Canadian | Oklahoma | 40017 | 1488 | 11 |
478353 | 478353 | 2020-08-28 | Canadian | Oklahoma | 40017 | 1502 | 11 |
481587 | 481587 | 2020-08-29 | Canadian | Oklahoma | 40017 | 1509 | 11 |
484822 | 484822 | 2020-08-30 | Canadian | Oklahoma | 40017 | 1518 | 11 |
488055 | 488055 | 2020-08-31 | Canadian | Oklahoma | 40017 | 1541 | 12 |
491288 | 491288 | 2020-09-01 | Canadian | Oklahoma | 40017 | 1547 | 12 |
494522 | 494522 | 2020-09-02 | Canadian | Oklahoma | 40017 | 1556 | 13 |
497755 | 497755 | 2020-09-03 | Canadian | Oklahoma | 40017 | 1568 | 13 |
500989 | 500989 | 2020-09-04 | Canadian | Oklahoma | 40017 | 1599 | 13 |
504223 | 504223 | 2020-09-05 | Canadian | Oklahoma | 40017 | 1615 | 13 |
507455 | 507455 | 2020-09-06 | Canadian | Oklahoma | 40017 | 1626 | 13 |
510688 | 510688 | 2020-09-07 | Canadian | Oklahoma | 40017 | 1634 | 13 |
513921 | 513921 | 2020-09-08 | Canadian | Oklahoma | 40017 | 1644 | 13 |
517156 | 517156 | 2020-09-09 | Canadian | Oklahoma | 40017 | 1664 | 13 |
520392 | 520392 | 2020-09-10 | Canadian | Oklahoma | 40017 | 1678 | 13 |
523628 | 523628 | 2020-09-11 | Canadian | Oklahoma | 40017 | 1695 | 13 |
526864 | 526864 | 2020-09-12 | Canadian | Oklahoma | 40017 | 1716 | 13 |
530101 | 530101 | 2020-09-13 | Canadian | Oklahoma | 40017 | 1736 | 13 |
533336 | 533336 | 2020-09-14 | Canadian | Oklahoma | 40017 | 1752 | 13 |
536572 | 536572 | 2020-09-15 | Canadian | Oklahoma | 40017 | 1783 | 13 |
539809 | 539809 | 2020-09-16 | Canadian | Oklahoma | 40017 | 1798 | 16 |
543045 | 543045 | 2020-09-17 | Canadian | Oklahoma | 40017 | 1827 | 16 |
546282 | 546282 | 2020-09-18 | Canadian | Oklahoma | 40017 | 1896 | 16 |
549521 | 549521 | 2020-09-19 | Canadian | Oklahoma | 40017 | 1928 | 16 |
552760 | 552760 | 2020-09-20 | Canadian | Oklahoma | 40017 | 1951 | 16 |
555997 | 555997 | 2020-09-21 | Canadian | Oklahoma | 40017 | 1998 | 16 |
559234 | 559234 | 2020-09-22 | Canadian | Oklahoma | 40017 | 2044 | 17 |
562471 | 562471 | 2020-09-23 | Canadian | Oklahoma | 40017 | 2087 | 17 |
565712 | 565712 | 2020-09-24 | Canadian | Oklahoma | 40017 | 2122 | 17 |
568953 | 568953 | 2020-09-25 | Canadian | Oklahoma | 40017 | 2178 | 17 |
572195 | 572195 | 2020-09-26 | Canadian | Oklahoma | 40017 | 2210 | 17 |
575439 | 575439 | 2020-09-27 | Canadian | Oklahoma | 40017 | 2267 | 17 |
578680 | 578680 | 2020-09-28 | Canadian | Oklahoma | 40017 | 2325 | 17 |
581920 | 581920 | 2020-09-29 | Canadian | Oklahoma | 40017 | 2360 | 17 |
585160 | 585160 | 2020-09-30 | Canadian | Oklahoma | 40017 | 2379 | 17 |
588400 | 588400 | 2020-10-01 | Canadian | Oklahoma | 40017 | 2415 | 17 |
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);