johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
354 rows where confirmed = 2404 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308667 | 308667 | 2022-12-13 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-14 04:21:04 | Clinch, Georgia, US | |
1149728 | 1149728 | 2022-12-12 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-13 04:21:01 | Clinch, Georgia, US | |
869582 | 869582 | 2022-12-11 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-12 04:21:01 | Clinch, Georgia, US | |
258112 | 258112 | 2022-12-10 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-11 04:20:50 | Clinch, Georgia, US | |
3936826 | 3936826 | 2022-12-09 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-10 04:21:02 | Clinch, Georgia, US | |
3378158 | 3378158 | 2022-12-08 | US | Georgia | Clinch | 13065 | 2404 | 45 | 0 | 30.91395822 | -82.70432472 | 2022-12-09 04:21:05 | Clinch, Georgia, US | |
2417312 | 2417312 | 2022-12-05 | US | North Dakota | Traill | 38097 | 2404 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-12-06 04:21:03 | Traill, North Dakota, US | |
2487745 | 2487745 | 2022-11-16 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-17 04:21:11 | Marshall, Minnesota, US | |
293756 | 293756 | 2022-11-15 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-16 04:21:09 | Marshall, Minnesota, US | |
3599094 | 3599094 | 2022-11-14 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-15 04:21:16 | Box Butte, Nebraska, US | |
3598786 | 3598786 | 2022-11-14 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-15 04:21:16 | Marshall, Minnesota, US | |
313952 | 313952 | 2022-11-13 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-14 04:21:09 | Box Butte, Nebraska, US | |
313644 | 313644 | 2022-11-13 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-14 04:21:09 | Marshall, Minnesota, US | |
65113 | 65113 | 2022-11-12 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-13 04:21:14 | Box Butte, Nebraska, US | |
64805 | 64805 | 2022-11-12 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-13 04:21:14 | Marshall, Minnesota, US | |
2929275 | 2929275 | 2022-11-11 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-12 04:20:41 | Box Butte, Nebraska, US | |
2928967 | 2928967 | 2022-11-11 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-12 04:20:41 | Marshall, Minnesota, US | |
2508111 | 2508111 | 2022-11-10 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-11 04:21:22 | Box Butte, Nebraska, US | |
2507803 | 2507803 | 2022-11-10 | US | Minnesota | Marshall | 27089 | 2404 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-11 04:21:22 | Marshall, Minnesota, US | |
2433145 | 2433145 | 2022-11-09 | US | New Mexico | Quay | 35037 | 2404 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-11-10 04:21:16 | Quay, New Mexico, US | |
2432986 | 2432986 | 2022-11-09 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-10 04:21:16 | Box Butte, Nebraska, US | |
2431464 | 2431464 | 2022-11-09 | US | Arkansas | Searcy | 5129 | 2404 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-11-10 04:21:16 | Searcy, Arkansas, US | |
481801 | 481801 | 2022-11-08 | US | New Mexico | Quay | 35037 | 2404 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-11-09 04:21:22 | Quay, New Mexico, US | |
481642 | 481642 | 2022-11-08 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-09 04:21:22 | Box Butte, Nebraska, US | |
2440792 | 2440792 | 2022-11-07 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-08 04:21:21 | Box Butte, Nebraska, US | |
1051890 | 1051890 | 2022-11-06 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-07 04:21:26 | Box Butte, Nebraska, US | |
619914 | 619914 | 2022-11-05 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-06 04:21:24 | Box Butte, Nebraska, US | |
1024418 | 1024418 | 2022-11-04 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-05 04:21:52 | Box Butte, Nebraska, US | |
433409 | 433409 | 2022-11-03 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-04 04:22:11 | Box Butte, Nebraska, US | |
851651 | 851651 | 2022-11-02 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-03 04:22:05 | Box Butte, Nebraska, US | |
713961 | 713961 | 2022-11-01 | US | West Virginia | Pleasants | 54073 | 2404 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-11-02 04:22:09 | Pleasants, West Virginia, US | |
712502 | 712502 | 2022-11-01 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-02 04:22:09 | Box Butte, Nebraska, US | |
3286951 | 3286951 | 2022-10-31 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-11-01 04:22:36 | Box Butte, Nebraska, US | |
321984 | 321984 | 2022-10-30 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-10-31 04:21:36 | Box Butte, Nebraska, US | |
914260 | 914260 | 2022-10-29 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-10-30 04:22:14 | Box Butte, Nebraska, US | |
1368529 | 1368529 | 2022-10-28 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-10-29 04:21:13 | Box Butte, Nebraska, US | |
3040384 | 3040384 | 2022-10-27 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-10-28 04:22:31 | Box Butte, Nebraska, US | |
540804 | 540804 | 2022-10-26 | US | Nebraska | Box Butte | 31013 | 2404 | 25 | 0 | 42.22079243 | -103.0878834 | 2022-10-27 04:22:01 | Box Butte, Nebraska, US | |
3217637 | 3217637 | 2022-10-12 | US | Virginia | Fairfax City | 51600 | 2404 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-10-13 04:22:39 | Fairfax City, Virginia, US | |
3253486 | 3253486 | 2022-10-11 | US | Virginia | Fairfax City | 51600 | 2404 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-10-12 04:22:51 | Fairfax City, Virginia, US | |
3250900 | 3250900 | 2022-10-11 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-12 04:22:51 | Atkinson, Georgia, US | |
2968159 | 2968159 | 2022-10-10 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-11 04:23:05 | Atkinson, Georgia, US | |
3098195 | 3098195 | 2022-10-09 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-10 04:22:32 | Atkinson, Georgia, US | |
3097253 | 3097253 | 2022-10-09 | China | Tianjin | 2404 | 3 | 0 | 39.3054 | 117.323 | 2022-10-10 04:22:32 | Tianjin, China | |||
4003420 | 4003420 | 2022-10-08 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-09 04:21:16 | Atkinson, Georgia, US | |
397017 | 397017 | 2022-10-07 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-08 04:22:56 | Atkinson, Georgia, US | |
2530134 | 2530134 | 2022-10-06 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-07 04:23:08 | Atkinson, Georgia, US | |
1811528 | 1811528 | 2022-10-05 | US | Georgia | Atkinson | 13003 | 2404 | 54 | 0 | 31.29633502 | -82.87545866 | 2022-10-06 04:21:22 | Atkinson, Georgia, US | |
133604 | 133604 | 2022-10-04 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-10-05 04:23:06 | Bon Homme, South Dakota, US | |
2688551 | 2688551 | 2022-10-03 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-10-04 04:22:55 | Bon Homme, South Dakota, US | |
2262618 | 2262618 | 2022-10-02 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-10-03 04:23:11 | Bon Homme, South Dakota, US | |
2998144 | 2998144 | 2022-10-01 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-10-02 04:21:23 | Bon Homme, South Dakota, US | |
856470 | 856470 | 2022-09-30 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-10-01 04:23:01 | Bon Homme, South Dakota, US | |
2378396 | 2378396 | 2022-09-29 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-09-30 04:23:09 | Bon Homme, South Dakota, US | |
1562947 | 1562947 | 2022-09-28 | US | South Dakota | Bon Homme | 46009 | 2404 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-09-29 04:22:34 | Bon Homme, South Dakota, US | |
1890879 | 1890879 | 2022-09-14 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-15 04:21:02 | Lake, Minnesota, US | |
373934 | 373934 | 2022-09-13 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-14 04:20:44 | Lake, Minnesota, US | |
2396536 | 2396536 | 2022-09-12 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-13 04:20:57 | Lake, Minnesota, US | |
3767614 | 3767614 | 2022-09-11 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-12 04:20:58 | Lake, Minnesota, US | |
3826189 | 3826189 | 2022-09-10 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-11 04:20:50 | Lake, Minnesota, US | |
964646 | 964646 | 2022-09-09 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-10 04:21:10 | Lake, Minnesota, US | |
255048 | 255048 | 2022-09-08 | US | Minnesota | Lake | 27075 | 2404 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-09 04:21:11 | Lake, Minnesota, US | |
1396626 | 1396626 | 2022-09-02 | US | Tennessee | Hancock | 47067 | 2404 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-09-03 04:21:04 | Hancock, Tennessee, US | |
3550455 | 3550455 | 2022-09-01 | US | Tennessee | Hancock | 47067 | 2404 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-09-02 04:21:07 | Hancock, Tennessee, US | |
1251752 | 1251752 | 2022-08-23 | US | Illinois | Hamilton | 17065 | 2404 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-08-24 04:20:46 | Hamilton, Illinois, US | |
1162312 | 1162312 | 2022-08-18 | US | Indiana | Switzerland | 18155 | 2404 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-08-19 04:20:54 | Switzerland, Indiana, US | |
3951636 | 3951636 | 2022-08-17 | US | Indiana | Switzerland | 18155 | 2404 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-08-18 04:21:11 | Switzerland, Indiana, US | |
1786277 | 1786277 | 2022-07-29 | US | Puerto Rico | Maunabo | 72095 | 2404 | 0 | 0 | 18.017889 | -65.922235 | 2022-07-30 04:20:42 | Maunabo, Puerto Rico, US | |
1068806 | 1068806 | 2022-07-28 | US | Tennessee | Clay | 47027 | 2404 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-29 04:20:45 | Clay, Tennessee, US | |
1608738 | 1608738 | 2022-07-20 | US | Arkansas | Cleveland | 5025 | 2404 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-07-21 04:21:10 | Cleveland, Arkansas, US | |
3213666 | 3213666 | 2022-07-18 | US | Virginia | Northampton | 51131 | 2404 | 66 | 0 | 37.34062933 | -75.87751591 | 2022-07-19 04:20:58 | Northampton, Virginia, US | |
3408791 | 3408791 | 2022-07-17 | US | Virginia | Essex | 51057 | 2404 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-18 04:20:59 | Essex, Virginia, US | |
2154991 | 2154991 | 2022-07-16 | US | Virginia | Essex | 51057 | 2404 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-17 04:21:15 | Essex, Virginia, US | |
2422224 | 2422224 | 2022-07-15 | US | Virginia | Essex | 51057 | 2404 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-16 04:21:05 | Essex, Virginia, US | |
3081258 | 3081258 | 2022-07-04 | US | Texas | Parmer | 48369 | 2404 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-05 04:20:45 | Parmer, Texas, US | |
1770540 | 1770540 | 2022-07-03 | US | Texas | Parmer | 48369 | 2404 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-04 04:20:54 | Parmer, Texas, US | |
3368526 | 3368526 | 2022-07-02 | US | Texas | Parmer | 48369 | 2404 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-03 04:20:59 | Parmer, Texas, US | |
596855 | 596855 | 2022-07-01 | US | Texas | Parmer | 48369 | 2404 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-02 04:21:16 | Parmer, Texas, US | |
2240201 | 2240201 | 2022-06-28 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-29 04:20:59 | Evans, Georgia, US | |
2148443 | 2148443 | 2022-06-27 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-28 04:20:58 | Evans, Georgia, US | |
478426 | 478426 | 2022-06-26 | US | Tennessee | Perry | 47135 | 2404 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-06-27 04:21:00 | Perry, Tennessee, US | |
476244 | 476244 | 2022-06-26 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-27 04:21:00 | Evans, Georgia, US | |
939619 | 939619 | 2022-06-25 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-26 04:21:02 | Evans, Georgia, US | |
3347439 | 3347439 | 2022-06-24 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-25 04:20:57 | Evans, Georgia, US | |
1649180 | 1649180 | 2022-06-23 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-24 04:20:58 | Evans, Georgia, US | |
2188415 | 2188415 | 2022-06-22 | US | Georgia | Evans | 13109 | 2404 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-06-23 04:20:55 | Evans, Georgia, US | |
1850953 | 1850953 | 2022-05-26 | US | Idaho | Washington | 16087 | 2404 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-27 04:20:56 | Washington, Idaho, US | |
2048829 | 2048829 | 2022-05-25 | US | Idaho | Washington | 16087 | 2404 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-26 04:20:50 | Washington, Idaho, US | |
622840 | 622840 | 2022-05-22 | US | Idaho | Washington | 16087 | 2404 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-26 04:20:50 | Washington, Idaho, US | |
3897943 | 3897943 | 2022-05-19 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-20 04:20:57 | Wayne, Missouri, US | |
1186727 | 1186727 | 2022-05-18 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-19 04:20:54 | Wayne, Missouri, US | |
3584624 | 3584624 | 2022-05-17 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-18 04:20:50 | Wayne, Missouri, US | |
1505581 | 1505581 | 2022-05-16 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-17 04:20:59 | Wayne, Missouri, US | |
2085940 | 2085940 | 2022-05-15 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-16 04:20:47 | Wayne, Missouri, US | |
3356650 | 3356650 | 2022-05-14 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-15 04:20:53 | Wayne, Missouri, US | |
660295 | 660295 | 2022-05-13 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-14 04:20:48 | Wayne, Missouri, US | |
2535378 | 2535378 | 2022-05-12 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-13 04:20:51 | Wayne, Missouri, US | |
3446824 | 3446824 | 2022-05-11 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-12 04:20:54 | Wayne, Missouri, US | |
3537441 | 3537441 | 2022-05-10 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-11 04:20:48 | Wayne, Missouri, US | |
223976 | 223976 | 2022-05-09 | US | Missouri | Wayne | 29223 | 2404 | 53 | 0 | 37.11303869 | -90.46001416 | 2022-05-10 04:20:50 | Wayne, Missouri, 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]);