johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
673 rows where deaths = 468 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 511
- Russia 39
- Sweden 22
- Malta 14
- Italy 10
- Colombia 9
- Canada 7
- India 6
- Netherlands 6
- Chile 5
- Japan 4
- Malaysia 4
- Mauritius 4
- Germany 3
- Mexico 3
- Pakistan 3
- Ukraine 3
- Australia 2
- Barbados 2
- Angola 1
- Azerbaijan 1
- Bahrain 1
- Belarus 1
- Dominican Republic 1
- Fiji 1
- Finland 1
- Guyana 1
- Korea, South 1
- Kuwait 1
- Mauritania 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755715 | 2755715 | 2022-12-29 | US | South Carolina | Berkeley | 45015 | 64135 | 468 | 0 | 33.20222596 | -79.94654523 | 2022-12-30 04:21:04 | Berkeley, South Carolina, US | |
2753765 | 2753765 | 2022-12-29 | US | Georgia | Paulding | 13223 | 45312 | 468 | 0 | 33.91969522 | -84.86848792 | 2022-12-30 04:21:04 | Paulding, Georgia, US | |
1076721 | 1076721 | 2022-12-28 | US | South Carolina | Berkeley | 45015 | 64135 | 468 | 0 | 33.20222596 | -79.94654523 | 2022-12-29 04:21:01 | Berkeley, South Carolina, US | |
1074771 | 1074771 | 2022-12-28 | US | Georgia | Paulding | 13223 | 45312 | 468 | 0 | 33.91969522 | -84.86848792 | 2022-12-29 04:21:01 | Paulding, Georgia, US | |
330718 | 330718 | 2022-12-27 | US | South Carolina | Berkeley | 45015 | 64135 | 468 | 0 | 33.20222596 | -79.94654523 | 2022-12-28 04:21:04 | Berkeley, South Carolina, US | |
1985546 | 1985546 | 2022-12-07 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-08 04:21:07 | Walton, Georgia, US | |
3715069 | 3715069 | 2022-12-06 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-07 04:20:58 | Walton, Georgia, US | |
2415774 | 2415774 | 2022-12-05 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-06 04:21:03 | Walton, Georgia, US | |
719382 | 719382 | 2022-12-04 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-05 04:20:58 | Walton, Georgia, US | |
2817671 | 2817671 | 2022-12-03 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-04 04:20:56 | Walton, Georgia, US | |
834527 | 834527 | 2022-12-02 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-03 04:21:02 | Walton, Georgia, US | |
2137057 | 2137057 | 2022-12-01 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-02 04:21:07 | Walton, Georgia, US | |
1965473 | 1965473 | 2022-11-30 | US | Georgia | Walton | 13297 | 25096 | 468 | 0 | 33.78017694 | -83.73552314 | 2022-12-01 04:21:03 | Walton, Georgia, US | |
2486592 | 2486592 | 2022-11-16 | US | California | Solano | 6095 | 114977 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-17 04:21:11 | Solano, California, US | |
292603 | 292603 | 2022-11-15 | US | California | Solano | 6095 | 114969 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-16 04:21:09 | Solano, California, US | |
3597633 | 3597633 | 2022-11-14 | US | California | Solano | 6095 | 114451 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-15 04:21:16 | Solano, California, US | |
312491 | 312491 | 2022-11-13 | US | California | Solano | 6095 | 114447 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-14 04:21:09 | Solano, California, US | |
63652 | 63652 | 2022-11-12 | US | California | Solano | 6095 | 114442 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-13 04:21:14 | Solano, California, US | |
2927814 | 2927814 | 2022-11-11 | US | California | Solano | 6095 | 114440 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-12 04:20:41 | Solano, California, US | |
2506650 | 2506650 | 2022-11-10 | US | California | Solano | 6095 | 114437 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-11 04:21:22 | Solano, California, US | |
2431525 | 2431525 | 2022-11-09 | US | California | Solano | 6095 | 114431 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-10 04:21:16 | Solano, California, US | |
480181 | 480181 | 2022-11-08 | US | California | Solano | 6095 | 114424 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-09 04:21:22 | Solano, California, US | |
2439331 | 2439331 | 2022-11-07 | US | California | Solano | 6095 | 114134 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-08 04:21:21 | Solano, California, US | |
1050429 | 1050429 | 2022-11-06 | US | California | Solano | 6095 | 114123 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-07 04:21:26 | Solano, California, US | |
618453 | 618453 | 2022-11-05 | US | California | Solano | 6095 | 114122 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-06 04:21:24 | Solano, California, US | |
1022957 | 1022957 | 2022-11-04 | US | California | Solano | 6095 | 114119 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-05 04:21:52 | Solano, California, US | |
431948 | 431948 | 2022-11-03 | US | California | Solano | 6095 | 114112 | 468 | 0 | 38.26827353 | -121.9357113 | 2022-11-04 04:22:11 | Solano, California, US | |
712767 | 712767 | 2022-11-01 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-11-02 04:22:09 | Davidson, North Carolina, US | |
3287216 | 3287216 | 2022-10-31 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-11-01 04:22:36 | Davidson, North Carolina, US | |
322249 | 322249 | 2022-10-30 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-10-31 04:21:36 | Davidson, North Carolina, US | |
914525 | 914525 | 2022-10-29 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-10-30 04:22:14 | Davidson, North Carolina, US | |
1368794 | 1368794 | 2022-10-28 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-10-29 04:21:13 | Davidson, North Carolina, US | |
3040649 | 3040649 | 2022-10-27 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-10-28 04:22:31 | Davidson, North Carolina, US | |
541069 | 541069 | 2022-10-26 | US | North Carolina | Davidson | 37057 | 51922 | 468 | 0 | 35.79115496 | -80.21256572 | 2022-10-27 04:22:01 | Davidson, North Carolina, US | |
2759892 | 2759892 | 2022-10-18 | US | Tennessee | Madison | 47113 | 35983 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-19 04:22:26 | Madison, Tennessee, US | |
2027726 | 2027726 | 2022-10-17 | US | Tennessee | Madison | 47113 | 35963 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-18 04:22:42 | Madison, Tennessee, US | |
2162504 | 2162504 | 2022-10-16 | US | Tennessee | Madison | 47113 | 35942 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-17 04:20:31 | Madison, Tennessee, US | |
518701 | 518701 | 2022-10-15 | US | Tennessee | Madison | 47113 | 35941 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-16 04:22:39 | Madison, Tennessee, US | |
2035758 | 2035758 | 2022-10-14 | US | Tennessee | Madison | 47113 | 35928 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-15 04:22:00 | Madison, Tennessee, US | |
3756446 | 3756446 | 2022-10-13 | US | Tennessee | Madison | 47113 | 35904 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-14 04:22:28 | Madison, Tennessee, US | |
3217271 | 3217271 | 2022-10-12 | US | Tennessee | Madison | 47113 | 35872 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-13 04:22:39 | Madison, Tennessee, US | |
3214712 | 3214712 | 2022-10-12 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-13 04:22:39 | Walker, Alabama, US | |
3253120 | 3253120 | 2022-10-11 | US | Tennessee | Madison | 47113 | 35849 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-12 04:22:51 | Madison, Tennessee, US | |
3250561 | 3250561 | 2022-10-11 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-12 04:22:51 | Walker, Alabama, US | |
2970379 | 2970379 | 2022-10-10 | US | Tennessee | Madison | 47113 | 35825 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-11 04:23:05 | Madison, Tennessee, US | |
2967820 | 2967820 | 2022-10-10 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-11 04:23:05 | Walker, Alabama, US | |
3100415 | 3100415 | 2022-10-09 | US | Tennessee | Madison | 47113 | 35798 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-10 04:22:32 | Madison, Tennessee, US | |
3097856 | 3097856 | 2022-10-09 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-10 04:22:32 | Walker, Alabama, US | |
4005640 | 4005640 | 2022-10-08 | US | Tennessee | Madison | 47113 | 35791 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-09 04:21:16 | Madison, Tennessee, US | |
4003081 | 4003081 | 2022-10-08 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-09 04:21:16 | Walker, Alabama, US | |
399237 | 399237 | 2022-10-07 | US | Tennessee | Madison | 47113 | 35781 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-08 04:22:56 | Madison, Tennessee, US | |
396678 | 396678 | 2022-10-07 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-08 04:22:56 | Walker, Alabama, US | |
2532354 | 2532354 | 2022-10-06 | US | Tennessee | Madison | 47113 | 35758 | 468 | 0 | 35.61181957 | -88.84076036 | 2022-10-07 04:23:08 | Madison, Tennessee, US | |
2529795 | 2529795 | 2022-10-06 | US | Alabama | Walker | 1127 | 22334 | 468 | 0 | 33.80270512 | -87.30027177 | 2022-10-07 04:23:08 | Walker, Alabama, US | |
2378052 | 2378052 | 2022-09-29 | US | Ohio | Portage | 39133 | 40431 | 468 | 0 | 41.16793482 | -81.19735782 | 2022-09-30 04:23:09 | Portage, Ohio, US | |
2769584 | 2769584 | 2022-09-26 | US | Colorado | Douglas | 8035 | 95426 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-27 04:23:01 | Douglas, Colorado, US | |
1977237 | 1977237 | 2022-09-25 | US | Colorado | Douglas | 8035 | 95361 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-26 04:20:52 | Douglas, Colorado, US | |
2650404 | 2650404 | 2022-09-24 | US | Colorado | Douglas | 8035 | 95361 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-25 04:23:31 | Douglas, Colorado, US | |
384844 | 384844 | 2022-09-23 | US | Colorado | Douglas | 8035 | 95361 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-24 04:21:40 | Douglas, Colorado, US | |
1624910 | 1624910 | 2022-09-22 | US | Colorado | Douglas | 8035 | 95324 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-23 04:23:13 | Douglas, Colorado, US | |
1371114 | 1371114 | 2022-09-21 | US | Colorado | Douglas | 8035 | 95284 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-22 04:22:56 | Douglas, Colorado, US | |
2017344 | 2017344 | 2022-09-20 | US | Colorado | Douglas | 8035 | 95234 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-21 04:23:22 | Douglas, Colorado, US | |
3571217 | 3571217 | 2022-09-19 | US | Colorado | Douglas | 8035 | 95205 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-20 04:22:48 | Douglas, Colorado, US | |
419956 | 419956 | 2022-09-18 | US | Colorado | Douglas | 8035 | 95131 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-19 04:21:49 | Douglas, Colorado, US | |
3373980 | 3373980 | 2022-09-17 | US | Colorado | Douglas | 8035 | 95131 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-18 04:22:50 | Douglas, Colorado, US | |
2356088 | 2356088 | 2022-09-16 | US | Colorado | Douglas | 8035 | 95131 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-17 04:20:19 | Douglas, Colorado, US | |
3987245 | 3987245 | 2022-09-15 | US | Colorado | Douglas | 8035 | 95107 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-16 04:21:19 | Douglas, Colorado, US | |
1889762 | 1889762 | 2022-09-14 | US | Colorado | Douglas | 8035 | 94988 | 468 | 0 | 39.33133796 | -104.930001 | 2022-09-15 04:21:02 | Douglas, Colorado, US | |
3745515 | 3745515 | 2022-09-07 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-08 04:21:02 | Shelby, Alabama, US | |
115155 | 115155 | 2022-09-06 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-07 04:20:59 | Shelby, Alabama, US | |
2634127 | 2634127 | 2022-09-05 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-06 04:21:02 | Shelby, Alabama, US | |
2987691 | 2987691 | 2022-09-04 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-05 04:21:01 | Shelby, Alabama, US | |
2713376 | 2713376 | 2022-09-03 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-04 04:21:22 | Shelby, Alabama, US | |
1394081 | 1394081 | 2022-09-02 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-03 04:21:04 | Shelby, Alabama, US | |
3547910 | 3547910 | 2022-09-01 | US | Alabama | Shelby | 1117 | 69590 | 468 | 0 | 33.26879845 | -86.66232561 | 2022-09-02 04:21:07 | Shelby, Alabama, US | |
1683422 | 1683422 | 2022-08-29 | US | Tennessee | Blount | 47009 | 44690 | 468 | 0 | 35.68938198 | -83.92847788 | 2022-08-30 04:21:03 | Blount, Tennessee, US | |
1680514 | 1680514 | 2022-08-29 | Japan | Nara | 192144 | 468 | 0 | 34.317451 | 135.871644 | 2022-08-30 04:21:03 | Nara, Japan | |||
1879906 | 1879906 | 2022-08-28 | US | Tennessee | Blount | 47009 | 44661 | 468 | 0 | 35.68938198 | -83.92847788 | 2022-08-29 04:21:06 | Blount, Tennessee, US | |
1876998 | 1876998 | 2022-08-28 | Japan | Nara | 190599 | 468 | 0 | 34.317451 | 135.871644 | 2022-08-29 04:21:06 | Nara, Japan | |||
991849 | 991849 | 2022-08-16 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-17 04:20:59 | Newton, Georgia, US | |
2494888 | 2494888 | 2022-08-15 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-16 04:20:58 | Newton, Georgia, US | |
3648438 | 3648438 | 2022-08-14 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-15 04:20:59 | Newton, Georgia, US | |
1969444 | 1969444 | 2022-08-13 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-14 04:20:55 | Newton, Georgia, US | |
2889253 | 2889253 | 2022-08-12 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-13 04:20:52 | Newton, Georgia, US | |
3908858 | 3908858 | 2022-08-11 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-12 04:20:54 | Newton, Georgia, US | |
3907759 | 3907759 | 2022-08-11 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-12 04:20:54 | Nova Scotia, Canada | |||
1347175 | 1347175 | 2022-08-10 | US | Georgia | Newton | 13217 | 27444 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-11 04:20:49 | Newton, Georgia, US | |
1346076 | 1346076 | 2022-08-10 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-11 04:20:49 | Nova Scotia, Canada | |||
1086930 | 1086930 | 2022-08-09 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-10 04:20:57 | Newton, Georgia, US | |
1085831 | 1085831 | 2022-08-09 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-10 04:20:57 | Nova Scotia, Canada | |||
3544345 | 3544345 | 2022-08-08 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-09 04:20:34 | Newton, Georgia, US | |
3543246 | 3543246 | 2022-08-08 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-09 04:20:34 | Nova Scotia, Canada | |||
1070748 | 1070748 | 2022-08-07 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-08 04:21:08 | Newton, Georgia, US | |
1069649 | 1069649 | 2022-08-07 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-08 04:21:08 | Nova Scotia, Canada | |||
1941336 | 1941336 | 2022-08-06 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-07 04:20:54 | Newton, Georgia, US | |
1940237 | 1940237 | 2022-08-06 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-07 04:20:54 | Nova Scotia, Canada | |||
881135 | 881135 | 2022-08-05 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-06 04:20:56 | Newton, Georgia, US | |
880036 | 880036 | 2022-08-05 | Canada | Nova Scotia | 115417 | 468 | 0 | 44.682 | -63.7443 | 2022-08-06 04:20:56 | Nova Scotia, Canada | |||
2009546 | 2009546 | 2022-08-04 | US | Georgia | Newton | 13217 | 27159 | 468 | 0 | 33.55514538 | -83.8454714 | 2022-08-05 04:20:52 | Newton, Georgia, US | |
2008714 | 2008714 | 2022-08-04 | Japan | Shizuoka | 284207 | 468 | 0 | 34.916975 | 138.407784 | 2022-08-05 04:20:52 | Shizuoka, Japan |
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]);