daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79,376 rows where province_or_state = "Oklahoma" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-04-23 | US | Oklahoma | Adair | 40001 | 7952 | 73 | 0 | 35.88494195 | -94.65859267 | 2022-04-24 04:20:56 | Adair, Oklahoma, US | |
2020-08-01 | US | Oklahoma | Adair | 40001 | 289 | 5 | 0 | 284 | 35.88494195 | -94.65859267 | 2020-08-02 04:34:47 | Adair, Oklahoma, US |
2020-10-28 | US | Oklahoma | Adair | 40001 | 815 | 11 | 0 | 804 | 35.88494195 | -94.65859267 | 2020-10-29 04:24:49 | Adair, Oklahoma, US |
2021-11-26 | US | Oklahoma | Adair | 40001 | 4995 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-11-27 04:22:45 | Adair, Oklahoma, US | |
2020-10-18 | US | Oklahoma | Adair | 40001 | 717 | 11 | 0 | 706 | 35.88494195 | -94.65859267 | 2020-10-19 04:24:16 | Adair, Oklahoma, US |
2020-12-29 | US | Oklahoma | Adair | 40001 | 1786 | 14 | 0 | 1772 | 35.88494195 | -94.65859267 | 2020-12-30 05:22:34 | Adair, Oklahoma, US |
2021-10-23 | US | Oklahoma | Adair | 40001 | 4850 | 61 | 0 | 35.88494195 | -94.65859267 | 2021-10-24 04:21:22 | Adair, Oklahoma, US | |
2021-01-12 | US | Oklahoma | Adair | 40001 | 2325 | 15 | 0 | 2310 | 35.88494195 | -94.65859267 | 2021-01-13 05:22:15 | Adair, Oklahoma, US |
2021-07-08 | US | Oklahoma | Adair | 40001 | 3242 | 44 | 0 | 35.88494195 | -94.65859267 | 2021-07-09 04:21:21 | Adair, Oklahoma, US | |
2021-12-13 | US | Oklahoma | Adair | 40001 | 5056 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-12-14 04:22:38 | Adair, Oklahoma, US | |
2020-10-15 | US | Oklahoma | Adair | 40001 | 715 | 11 | 0 | 704 | 35.88494195 | -94.65859267 | 2020-10-16 04:24:01 | Adair, Oklahoma, US |
2021-02-04 | US | Oklahoma | Adair | 40001 | 2928 | 20 | 0 | 2908 | 35.88494195 | -94.65859267 | 2021-02-05 05:22:38 | Adair, Oklahoma, US |
2022-10-24 | US | Oklahoma | Adair | 40001 | 9308 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-10-25 04:21:53 | Adair, Oklahoma, US | |
2021-12-22 | US | Oklahoma | Adair | 40001 | 5123 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-12-23 04:21:21 | Adair, Oklahoma, US | |
2020-06-01 | US | Oklahoma | Adair | 40001 | 88 | 3 | 0 | 85 | 35.88494195 | -94.65859267 | 2020-06-02 02:33:08 | Adair, Oklahoma, US |
2020-03-27 | US | Oklahoma | Adair | 40001 | 3 | 0 | 0 | 3 | 35.88494195 | -94.65859267 | 2020-03-27 22:14:55 | Adair, Oklahoma, US |
2021-09-20 | US | Oklahoma | Adair | 40001 | 4601 | 53 | 0 | 35.88494195 | -94.65859267 | 2021-09-21 04:21:26 | Adair, Oklahoma, US | |
2020-09-05 | US | Oklahoma | Adair | 40001 | 494 | 10 | 0 | 484 | 35.88494195 | -94.65859267 | 2020-09-06 04:28:33 | Adair, Oklahoma, US |
2020-10-09 | US | Oklahoma | Adair | 40001 | 685 | 10 | 0 | 675 | 35.88494195 | -94.65859267 | 2020-10-10 04:23:57 | Adair, Oklahoma, US |
2020-11-19 | US | Oklahoma | Adair | 40001 | 1093 | 13 | 0 | 1080 | 35.88494195 | -94.65859267 | 2020-11-20 05:26:28 | Adair, Oklahoma, US |
2021-06-06 | US | Oklahoma | Adair | 40001 | 3192 | 43 | 0 | 35.88494195 | -94.65859267 | 2021-06-07 04:22:51 | Adair, Oklahoma, US | |
2021-07-09 | US | Oklahoma | Adair | 40001 | 3242 | 44 | 0 | 35.88494195 | -94.65859267 | 2021-07-10 04:21:25 | Adair, Oklahoma, US | |
2022-12-02 | US | Oklahoma | Adair | 40001 | 9421 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-03 04:21:02 | Adair, Oklahoma, US | |
2020-08-17 | US | Oklahoma | Adair | 40001 | 383 | 6 | 0 | 377 | 35.88494195 | -94.65859267 | 2020-08-18 04:27:56 | Adair, Oklahoma, US |
2020-07-22 | US | Oklahoma | Adair | 40001 | 205 | 4 | 0 | 201 | 35.88494195 | -94.65859267 | 2020-07-23 05:15:04 | Adair, Oklahoma, US |
2020-12-12 | US | Oklahoma | Adair | 40001 | 1465 | 13 | 0 | 1452 | 35.88494195 | -94.65859267 | 2020-12-13 05:27:20 | Adair, Oklahoma, US |
2022-11-02 | US | Oklahoma | Adair | 40001 | 9323 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-11-03 04:22:05 | Adair, Oklahoma, US | |
2022-09-30 | US | Oklahoma | Adair | 40001 | 9264 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-10-01 04:23:01 | Adair, Oklahoma, US | |
2020-04-15 | US | Oklahoma | Adair | 40001 | 29 | 3 | 0 | 26 | 35.88494195 | -94.65859267 | 2020-04-15 22:56:51 | Adair, Oklahoma, US |
2020-12-11 | US | Oklahoma | Adair | 40001 | 1438 | 13 | 0 | 1425 | 35.88494195 | -94.65859267 | 2020-12-12 05:26:19 | Adair, Oklahoma, US |
2020-11-12 | US | Oklahoma | Adair | 40001 | 1018 | 13 | 0 | 1005 | 35.88494195 | -94.65859267 | 2020-11-13 05:25:30 | Adair, Oklahoma, US |
2022-12-11 | US | Oklahoma | Adair | 40001 | 9448 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-12 04:21:01 | Adair, Oklahoma, US | |
2020-05-24 | US | Oklahoma | Adair | 40001 | 82 | 3 | 0 | 79 | 35.88494195 | -94.65859267 | 2020-05-25 02:32:44 | Adair, Oklahoma, US |
2022-03-27 | US | Oklahoma | Adair | 40001 | 7841 | 72 | 0 | 35.88494195 | -94.65859267 | 2022-03-28 04:20:33 | Adair, Oklahoma, US | |
2022-08-05 | US | Oklahoma | Adair | 40001 | 8655 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-08-06 04:20:56 | Adair, Oklahoma, US | |
2020-07-07 | US | Oklahoma | Adair | 40001 | 129 | 4 | 0 | 125 | 35.88494195 | -94.65859267 | 2020-07-08 05:33:48 | Adair, Oklahoma, US |
2021-04-26 | US | Oklahoma | Adair | 40001 | 3163 | 39 | 0 | 35.88494195 | -94.65859267 | 2021-04-27 04:20:52 | Adair, Oklahoma, US | |
2020-11-05 | US | Oklahoma | Adair | 40001 | 912 | 12 | 0 | 900 | 35.88494195 | -94.65859267 | 2020-11-06 05:24:55 | Adair, Oklahoma, US |
2022-07-24 | US | Oklahoma | Adair | 40001 | 8463 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-07-25 04:20:51 | Adair, Oklahoma, US | |
2022-07-22 | US | Oklahoma | Adair | 40001 | 8463 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-07-23 04:20:53 | Adair, Oklahoma, US | |
2021-11-24 | US | Oklahoma | Adair | 40001 | 4995 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-11-25 04:22:33 | Adair, Oklahoma, US | |
2021-01-19 | US | Oklahoma | Adair | 40001 | 2544 | 17 | 0 | 2527 | 35.88494195 | -94.65859267 | 2021-01-20 05:21:54 | Adair, Oklahoma, US |
2022-10-29 | US | Oklahoma | Adair | 40001 | 9323 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-10-30 04:22:14 | Adair, Oklahoma, US | |
2020-03-26 | US | Oklahoma | Adair | 40001 | 2 | 0 | 0 | 2 | 35.88494195 | -94.65859267 | 2020-03-26 23:48:35 | Adair, Oklahoma, US |
2022-03-08 | US | Oklahoma | Adair | 40001 | 7808 | 69 | 0 | 35.88494195 | -94.65859267 | 2022-03-09 04:20:59 | Adair, Oklahoma, US | |
2020-11-26 | US | Oklahoma | Adair | 40001 | 1149 | 13 | 0 | 1136 | 35.88494195 | -94.65859267 | 2020-11-27 05:26:53 | Adair, Oklahoma, US |
2020-12-21 | US | Oklahoma | Adair | 40001 | 1694 | 13 | 0 | 1681 | 35.88494195 | -94.65859267 | 2020-12-22 05:22:33 | Adair, Oklahoma, US |
2020-04-16 | US | Oklahoma | Adair | 40001 | 29 | 3 | 0 | 26 | 35.88494195 | -94.65859267 | 2020-04-16 23:30:51 | Adair, Oklahoma, US |
2021-10-16 | US | Oklahoma | Adair | 40001 | 4818 | 57 | 0 | 35.88494195 | -94.65859267 | 2021-10-17 04:21:29 | Adair, Oklahoma, US | |
2022-06-25 | US | Oklahoma | Adair | 40001 | 8111 | 75 | 0 | 35.88494195 | -94.65859267 | 2022-06-26 04:21:02 | Adair, Oklahoma, US | |
2022-02-28 | US | Oklahoma | Adair | 40001 | 7767 | 68 | 0 | 35.88494195 | -94.65859267 | 2022-03-01 04:21:09 | Adair, Oklahoma, US | |
2022-06-14 | US | Oklahoma | Adair | 40001 | 8055 | 75 | 0 | 35.88494195 | -94.65859267 | 2022-06-15 04:20:54 | Adair, Oklahoma, US | |
2022-03-12 | US | Oklahoma | Adair | 40001 | 7830 | 70 | 0 | 35.88494195 | -94.65859267 | 2022-03-13 04:20:49 | Adair, Oklahoma, US | |
2021-04-25 | US | Oklahoma | Adair | 40001 | 3163 | 39 | 0 | 35.88494195 | -94.65859267 | 2021-04-26 04:21:04 | Adair, Oklahoma, US | |
2022-07-19 | US | Oklahoma | Adair | 40001 | 8368 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-07-20 04:20:59 | Adair, Oklahoma, US | |
2022-09-09 | US | Oklahoma | Adair | 40001 | 9154 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-09-10 04:21:10 | Adair, Oklahoma, US | |
2020-09-29 | US | Oklahoma | Adair | 40001 | 634 | 10 | 0 | 624 | 35.88494195 | -94.65859267 | 2020-09-30 04:23:33 | Adair, Oklahoma, US |
2022-06-01 | US | Oklahoma | Adair | 40001 | 8025 | 75 | 0 | 35.88494195 | -94.65859267 | 2022-06-02 05:20:39 | Adair, Oklahoma, US | |
2021-02-06 | US | Oklahoma | Adair | 40001 | 2966 | 20 | 0 | 2946 | 35.88494195 | -94.65859267 | 2021-02-07 05:23:00 | Adair, Oklahoma, US |
2022-02-01 | US | Oklahoma | Adair | 40001 | 6678 | 65 | 0 | 35.88494195 | -94.65859267 | 2022-02-02 04:21:09 | Adair, Oklahoma, US | |
2021-04-17 | US | Oklahoma | Adair | 40001 | 3159 | 38 | 0 | 35.88494195 | -94.65859267 | 2021-04-18 04:20:41 | Adair, Oklahoma, US | |
2021-10-04 | US | Oklahoma | Adair | 40001 | 4729 | 55 | 0 | 35.88494195 | -94.65859267 | 2021-10-05 04:21:27 | Adair, Oklahoma, US | |
2022-08-16 | US | Oklahoma | Adair | 40001 | 8772 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-08-17 04:20:59 | Adair, Oklahoma, US | |
2020-05-23 | US | Oklahoma | Adair | 40001 | 82 | 3 | 0 | 79 | 35.88494195 | -94.65859267 | 2020-05-24 02:32:43 | Adair, Oklahoma, US |
2021-03-01 | US | Oklahoma | Adair | 40001 | 3096 | 24 | 0 | 3072 | 35.88494195 | -94.65859267 | 2021-03-02 05:23:30 | Adair, Oklahoma, US |
2020-07-09 | US | Oklahoma | Adair | 40001 | 136 | 4 | 0 | 132 | 35.88494195 | -94.65859267 | 2020-07-10 04:34:24 | Adair, Oklahoma, US |
2020-12-06 | US | Oklahoma | Adair | 40001 | 1343 | 13 | 0 | 1330 | 35.88494195 | -94.65859267 | 2020-12-07 05:26:14 | Adair, Oklahoma, US |
2020-12-30 | US | Oklahoma | Adair | 40001 | 1820 | 14 | 0 | 1806 | 35.88494195 | -94.65859267 | 2020-12-31 05:22:49 | Adair, Oklahoma, US |
2021-11-21 | US | Oklahoma | Adair | 40001 | 4962 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-11-22 04:22:20 | Adair, Oklahoma, US | |
2022-12-24 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-25 04:21:04 | Adair, Oklahoma, US | |
2022-11-04 | US | Oklahoma | Adair | 40001 | 9334 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-11-05 04:21:52 | Adair, Oklahoma, US | |
2020-10-17 | US | Oklahoma | Adair | 40001 | 719 | 11 | 0 | 708 | 35.88494195 | -94.65859267 | 2020-10-18 04:24:25 | Adair, Oklahoma, US |
2021-12-06 | US | Oklahoma | Adair | 40001 | 5020 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-12-07 04:22:34 | Adair, Oklahoma, US | |
2020-12-15 | US | Oklahoma | Adair | 40001 | 1515 | 13 | 0 | 1502 | 35.88494195 | -94.65859267 | 2020-12-16 05:28:04 | Adair, Oklahoma, US |
2020-05-26 | US | Oklahoma | Adair | 40001 | 82 | 3 | 0 | 79 | 35.88494195 | -94.65859267 | 2020-05-27 02:32:31 | Adair, Oklahoma, US |
2020-10-07 | US | Oklahoma | Adair | 40001 | 666 | 10 | 0 | 656 | 35.88494195 | -94.65859267 | 2020-10-08 04:23:56 | Adair, Oklahoma, US |
2020-09-30 | US | Oklahoma | Adair | 40001 | 639 | 10 | 0 | 629 | 35.88494195 | -94.65859267 | 2020-10-01 04:23:42 | Adair, Oklahoma, US |
2022-11-06 | US | Oklahoma | Adair | 40001 | 9334 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-11-07 04:21:26 | Adair, Oklahoma, US | |
2020-10-23 | US | Oklahoma | Adair | 40001 | 769 | 11 | 0 | 758 | 35.88494195 | -94.65859267 | 2020-10-24 04:24:46 | Adair, Oklahoma, US |
2022-02-23 | US | Oklahoma | Adair | 40001 | 7767 | 68 | 0 | 35.88494195 | -94.65859267 | 2022-02-24 04:21:14 | Adair, Oklahoma, US | |
2021-01-04 | US | Oklahoma | Adair | 40001 | 1988 | 14 | 0 | 1974 | 35.88494195 | -94.65859267 | 2021-01-05 05:21:49 | Adair, Oklahoma, US |
2022-07-28 | US | Oklahoma | Adair | 40001 | 8577 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-07-29 04:20:45 | Adair, Oklahoma, US | |
2022-08-07 | US | Oklahoma | Adair | 40001 | 8655 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-08-08 04:21:08 | Adair, Oklahoma, US | |
2022-12-28 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-29 04:21:01 | Adair, Oklahoma, US | |
2021-12-09 | US | Oklahoma | Adair | 40001 | 5056 | 62 | 0 | 35.88494195 | -94.65859267 | 2021-12-10 04:22:28 | Adair, Oklahoma, US | |
2021-05-14 | US | Oklahoma | Adair | 40001 | 3181 | 41 | 0 | 35.88494195 | -94.65859267 | 2021-05-15 04:20:58 | Adair, Oklahoma, US | |
2022-08-09 | US | Oklahoma | Adair | 40001 | 8655 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-08-10 04:20:57 | Adair, Oklahoma, US | |
2021-03-03 | US | Oklahoma | Adair | 40001 | 3097 | 25 | 0 | 3072 | 35.88494195 | -94.65859267 | 2021-03-04 05:24:24 | Adair, Oklahoma, US |
2021-01-20 | US | Oklahoma | Adair | 40001 | 2554 | 17 | 0 | 2537 | 35.88494195 | -94.65859267 | 2021-01-21 05:22:01 | Adair, Oklahoma, US |
2022-08-03 | US | Oklahoma | Adair | 40001 | 8577 | 77 | 0 | 35.88494195 | -94.65859267 | 2022-08-04 04:20:58 | Adair, Oklahoma, US | |
2020-05-25 | US | Oklahoma | Adair | 40001 | 82 | 3 | 0 | 79 | 35.88494195 | -94.65859267 | 2020-05-26 02:32:35 | Adair, Oklahoma, US |
2020-09-02 | US | Oklahoma | Adair | 40001 | 469 | 10 | 0 | 459 | 35.88494195 | -94.65859267 | 2020-09-03 04:28:22 | Adair, Oklahoma, US |
2022-05-21 | US | Oklahoma | Adair | 40001 | 8011 | 75 | 0 | 35.88494195 | -94.65859267 | 2022-05-22 04:20:52 | Adair, Oklahoma, US | |
2022-01-11 | US | Oklahoma | Adair | 40001 | 5218 | 63 | 0 | 35.88494195 | -94.65859267 | 2022-01-12 04:21:44 | Adair, Oklahoma, US | |
2021-08-06 | US | Oklahoma | Adair | 40001 | 3601 | 45 | 0 | 35.88494195 | -94.65859267 | 2021-08-07 04:21:30 | Adair, Oklahoma, US | |
2020-09-17 | US | Oklahoma | Adair | 40001 | 559 | 10 | 0 | 549 | 35.88494195 | -94.65859267 | 2020-09-18 05:05:00 | Adair, Oklahoma, US |
2021-06-18 | US | Oklahoma | Adair | 40001 | 3204 | 44 | 0 | 35.88494195 | -94.65859267 | 2021-06-19 04:22:33 | Adair, Oklahoma, US | |
2020-03-25 | US | Oklahoma | Adair | 40001 | 2 | 0 | 0 | 2 | 35.88494195 | -94.65859267 | 2020-03-25 23:33:19 | Adair, Oklahoma, US |
2020-06-26 | US | Oklahoma | Adair | 40001 | 111 | 4 | 0 | 107 | 35.88494195 | -94.65859267 | 2020-06-27 04:33:35 | Adair, Oklahoma, US |
2021-01-01 | US | Oklahoma | Adair | 40001 | 1870 | 14 | 0 | 1856 | 35.88494195 | -94.65859267 | 2021-01-02 05:22:33 | Adair, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;