johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
848 rows where confirmed = 312 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331094 | 331094 | 2022-12-27 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-28 04:21:04 | Motley, Texas, US | |
221167 | 221167 | 2022-12-26 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-27 04:21:07 | Motley, Texas, US | |
3225624 | 3225624 | 2022-12-25 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-26 04:21:06 | Motley, Texas, US | |
1021538 | 1021538 | 2022-12-24 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-25 04:21:04 | Motley, Texas, US | |
693561 | 693561 | 2022-12-23 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-24 04:21:02 | Motley, Texas, US | |
2182771 | 2182771 | 2022-12-22 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-23 04:21:04 | Motley, Texas, US | |
454575 | 454575 | 2022-12-21 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-22 04:20:56 | Motley, Texas, US | |
310507 | 310507 | 2022-12-13 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-14 04:21:04 | Gilliam, Oregon, US | |
1151568 | 1151568 | 2022-12-12 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-13 04:21:01 | Gilliam, Oregon, US | |
871422 | 871422 | 2022-12-11 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-12 04:21:01 | Gilliam, Oregon, US | |
259952 | 259952 | 2022-12-10 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-11 04:20:50 | Gilliam, Oregon, US | |
3938666 | 3938666 | 2022-12-09 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-10 04:21:02 | Gilliam, Oregon, US | |
3379998 | 3379998 | 2022-12-08 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-09 04:21:05 | Gilliam, Oregon, US | |
1987269 | 1987269 | 2022-12-07 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-08 04:21:07 | Gilliam, Oregon, US | |
3717400 | 3717400 | 2022-12-06 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-07 04:20:58 | Sterling, Texas, US | |
3716792 | 3716792 | 2022-12-06 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-07 04:20:58 | Gilliam, Oregon, US | |
2418105 | 2418105 | 2022-12-05 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-06 04:21:03 | Sterling, Texas, US | |
2417497 | 2417497 | 2022-12-05 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-06 04:21:03 | Gilliam, Oregon, US | |
721713 | 721713 | 2022-12-04 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-05 04:20:58 | Sterling, Texas, US | |
721105 | 721105 | 2022-12-04 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-05 04:20:58 | Gilliam, Oregon, US | |
2820002 | 2820002 | 2022-12-03 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-04 04:20:56 | Sterling, Texas, US | |
2819394 | 2819394 | 2022-12-03 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-04 04:20:56 | Gilliam, Oregon, US | |
836858 | 836858 | 2022-12-02 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-03 04:21:02 | Sterling, Texas, US | |
836250 | 836250 | 2022-12-02 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-03 04:21:02 | Gilliam, Oregon, US | |
2139388 | 2139388 | 2022-12-01 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-02 04:21:07 | Sterling, Texas, US | |
2138780 | 2138780 | 2022-12-01 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-02 04:21:07 | Gilliam, Oregon, US | |
1967804 | 1967804 | 2022-11-30 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-01 04:21:03 | Sterling, Texas, US | |
1967196 | 1967196 | 2022-11-30 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-01 04:21:03 | Gilliam, Oregon, US | |
2559818 | 2559818 | 2022-11-29 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-11-30 04:21:07 | Sterling, Texas, US | |
2559210 | 2559210 | 2022-11-29 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-30 04:21:07 | Gilliam, Oregon, US | |
1242892 | 1242892 | 2022-11-28 | US | Texas | Sterling | 48431 | 312 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-11-29 04:21:05 | Sterling, Texas, US | |
1242284 | 1242284 | 2022-11-28 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-29 04:21:05 | Gilliam, Oregon, US | |
3554272 | 3554272 | 2022-11-27 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-28 04:21:02 | Gilliam, Oregon, US | |
2102752 | 2102752 | 2022-11-26 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-27 04:21:05 | Gilliam, Oregon, US | |
490243 | 490243 | 2022-11-25 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-26 04:21:11 | Gilliam, Oregon, US | |
3526072 | 3526072 | 2022-11-24 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-25 04:21:06 | Gilliam, Oregon, US | |
3314855 | 3314855 | 2022-11-23 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-24 04:21:09 | Gilliam, Oregon, US | |
1622896 | 1622896 | 2022-11-22 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-23 04:21:06 | Gilliam, Oregon, US | |
3462784 | 3462784 | 2022-11-21 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-22 04:20:47 | Gilliam, Oregon, US | |
1642969 | 1642969 | 2022-11-20 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-21 04:21:05 | Gilliam, Oregon, US | |
2066526 | 2066526 | 2022-11-19 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-20 04:21:08 | Gilliam, Oregon, US | |
1757920 | 1757920 | 2022-11-18 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-19 04:21:14 | Gilliam, Oregon, US | |
3028913 | 3028913 | 2022-11-17 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-18 04:21:15 | Gilliam, Oregon, US | |
2488624 | 2488624 | 2022-11-16 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-17 04:21:11 | Gilliam, Oregon, US | |
294635 | 294635 | 2022-11-15 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-16 04:21:09 | Gilliam, Oregon, US | |
3599665 | 3599665 | 2022-11-14 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-15 04:21:16 | Gilliam, Oregon, US | |
314523 | 314523 | 2022-11-13 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-14 04:21:09 | Gilliam, Oregon, US | |
65684 | 65684 | 2022-11-12 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-13 04:21:14 | Gilliam, Oregon, US | |
62866 | 62866 | 2022-11-12 | China | Qinghai | 312 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-13 04:21:14 | Qinghai, China | |||
2929846 | 2929846 | 2022-11-11 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-12 04:20:41 | Gilliam, Oregon, US | |
2508682 | 2508682 | 2022-11-10 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-11 04:21:22 | Gilliam, Oregon, US | |
2433557 | 2433557 | 2022-11-09 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-10 04:21:16 | Gilliam, Oregon, US | |
482213 | 482213 | 2022-11-08 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-09 04:21:22 | Gilliam, Oregon, US | |
2441363 | 2441363 | 2022-11-07 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-08 04:21:21 | Gilliam, Oregon, US | |
1052461 | 1052461 | 2022-11-06 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-07 04:21:26 | Gilliam, Oregon, US | |
620485 | 620485 | 2022-11-05 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-06 04:21:24 | Gilliam, Oregon, US | |
1024989 | 1024989 | 2022-11-04 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-05 04:21:52 | Gilliam, Oregon, US | |
433980 | 433980 | 2022-11-03 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-04 04:22:11 | Gilliam, Oregon, US | |
852222 | 852222 | 2022-11-02 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-03 04:22:05 | Gilliam, Oregon, US | |
713073 | 713073 | 2022-11-01 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-02 04:22:09 | Gilliam, Oregon, US | |
3287522 | 3287522 | 2022-10-31 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-11-01 04:22:36 | Gilliam, Oregon, US | |
322555 | 322555 | 2022-10-30 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-10-31 04:21:36 | Gilliam, Oregon, US | |
914831 | 914831 | 2022-10-29 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-10-30 04:22:14 | Gilliam, Oregon, US | |
1369100 | 1369100 | 2022-10-28 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-10-29 04:21:13 | Gilliam, Oregon, US | |
3040955 | 3040955 | 2022-10-27 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-10-28 04:22:31 | Gilliam, Oregon, US | |
541375 | 541375 | 2022-10-26 | US | Oregon | Gilliam | 41021 | 312 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-10-27 04:22:01 | Gilliam, Oregon, US | |
3545918 | 3545918 | 2022-08-08 | US | North Dakota | Sheridan | 38083 | 312 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-09 04:20:34 | Sheridan, North Dakota, US | |
1406353 | 1406353 | 2022-08-02 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-03 04:20:59 | Lane, Kansas, US | |
3618391 | 3618391 | 2022-08-01 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-02 04:20:53 | Lane, Kansas, US | |
3872871 | 3872871 | 2022-07-31 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-01 04:21:03 | Lane, Kansas, US | |
675625 | 675625 | 2022-07-30 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-07-31 04:21:02 | Lane, Kansas, US | |
1784824 | 1784824 | 2022-07-29 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-07-30 04:20:42 | Lane, Kansas, US | |
1067187 | 1067187 | 2022-07-28 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-07-29 04:20:45 | Lane, Kansas, US | |
2336706 | 2336706 | 2022-07-27 | US | Kansas | Lane | 20101 | 312 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-07-28 04:20:56 | Lane, Kansas, US | |
2242281 | 2242281 | 2022-06-28 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-29 04:20:59 | Hyde, South Dakota, US | |
2150523 | 2150523 | 2022-06-27 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-28 04:20:58 | Hyde, South Dakota, US | |
478324 | 478324 | 2022-06-26 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-27 04:21:00 | Hyde, South Dakota, US | |
941699 | 941699 | 2022-06-25 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-26 04:21:02 | Hyde, South Dakota, US | |
3349519 | 3349519 | 2022-06-24 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-25 04:20:57 | Hyde, South Dakota, US | |
1651260 | 1651260 | 2022-06-23 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-24 04:20:58 | Hyde, South Dakota, US | |
2190495 | 2190495 | 2022-06-22 | US | South Dakota | Hyde | 46069 | 312 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-06-23 04:20:55 | Hyde, South Dakota, US | |
2727757 | 2727757 | 2022-05-28 | US | Puerto Rico | Culebra | 72049 | 312 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-29 04:20:53 | Culebra, Puerto Rico, US | |
1316938 | 1316938 | 2022-05-27 | US | Puerto Rico | Culebra | 72049 | 312 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-28 04:21:07 | Culebra, Puerto Rico, US | |
3584500 | 3584500 | 2022-05-17 | US | Mississippi | Unassigned | 90028 | 312 | 1 | 0 | 34.88084463 | 0.0 | 2022-05-18 04:20:50 | Unassigned, Mississippi, US | |
1513474 | 1513474 | 2022-02-24 | US | Nebraska | Deuel | 31049 | 312 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2022-02-25 04:21:11 | Deuel, Nebraska, US | |
3074630 | 3074630 | 2022-02-09 | US | California | Sierra | 6091 | 312 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-02-10 04:21:14 | Sierra, California, US | |
2327971 | 2327971 | 2022-02-04 | US | Colorado | Cheyenne | 8017 | 312 | 9 | 0 | 38.82777431 | -102.6032558 | 2022-02-05 04:21:05 | Cheyenne, Colorado, US | |
2476104 | 2476104 | 2022-02-03 | US | Nevada | Storey | 32029 | 312 | 9 | 0 | 39.44875482 | -119.5250207 | 2022-02-04 04:21:10 | Storey, Nevada, US | |
1115667 | 1115667 | 2022-01-11 | US | Nebraska | Gosper | 31073 | 312 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-01-12 04:21:44 | Gosper, Nebraska, US | |
1693183 | 1693183 | 2022-01-10 | US | Georgia | Quitman | 13239 | 312 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-01-11 04:22:01 | Quitman, Georgia, US | |
1703383 | 1703383 | 2022-01-03 | US | Texas | Briscoe | 48045 | 312 | 7 | 0 | 34.53026962 | -101.2084947 | 2022-01-04 04:22:17 | Briscoe, Texas, US | |
3522466 | 3522466 | 2022-01-02 | US | Texas | Briscoe | 48045 | 312 | 7 | 0 | 34.53026962 | -101.2084947 | 2022-01-03 02:22:25 | Briscoe, Texas, US | |
3521509 | 3521509 | 2022-01-02 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-03 02:22:25 | Garfield, Nebraska, US | |
2169639 | 2169639 | 2022-01-01 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-02 04:20:52 | Garfield, Nebraska, US | |
2779070 | 2779070 | 2021-12-31 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-01 04:22:14 | Garfield, Nebraska, US | |
4000727 | 4000727 | 2021-12-30 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2021-12-31 04:21:50 | Garfield, Nebraska, US | |
1670534 | 1670534 | 2021-12-29 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2021-12-30 04:21:25 | Garfield, Nebraska, US | |
1434643 | 1434643 | 2021-12-28 | US | Nebraska | Garfield | 31071 | 312 | 1 | 0 | 41.91428955 | -98.99111827 | 2021-12-29 03:21:43 | Garfield, Nebraska, US | |
2115165 | 2115165 | 2021-12-26 | US | Washington | Wahkiakum | 53069 | 312 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-12-27 04:21:58 | Wahkiakum, Washington, US | |
2113693 | 2113693 | 2021-12-26 | US | Montana | Daniels | 30019 | 312 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-12-27 04:21:58 | Daniels, Montana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);