johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
812 rows where confirmed = 413 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1594642 | 1594642 | 2022-10-21 | US | North Dakota | Steele | 38091 | 413 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-10-22 04:22:53 | Steele, North Dakota, US | |
2274358 | 2274358 | 2022-10-20 | US | North Dakota | Steele | 38091 | 413 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-10-21 04:22:23 | Steele, North Dakota, US | |
200693 | 200693 | 2022-10-19 | US | North Dakota | Steele | 38091 | 413 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-10-20 04:22:59 | Steele, North Dakota, US | |
2759354 | 2759354 | 2022-10-18 | US | North Dakota | Steele | 38091 | 413 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-10-19 04:22:26 | Steele, North Dakota, US | |
2027188 | 2027188 | 2022-10-17 | US | North Dakota | Steele | 38091 | 413 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-10-18 04:22:42 | Steele, North Dakota, US | |
3911361 | 3911361 | 2022-08-11 | US | Virginia | Highland | 51091 | 413 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-08-12 04:20:54 | Highland, Virginia, US | |
3910742 | 3910742 | 2022-08-11 | US | Puerto Rico | Culebra | 72049 | 413 | 0 | 0 | 18.31586 | -65.28813 | 2022-08-12 04:20:54 | Culebra, Puerto Rico, US | |
1349678 | 1349678 | 2022-08-10 | US | Virginia | Highland | 51091 | 413 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-08-11 04:20:49 | Highland, Virginia, US | |
2149691 | 2149691 | 2022-06-27 | US | Nebraska | Boyd | 31015 | 413 | 6 | 0 | 42.8997274 | -98.76486568 | 2022-06-28 04:20:58 | Boyd, Nebraska, US | |
477492 | 477492 | 2022-06-26 | US | Nebraska | Boyd | 31015 | 413 | 6 | 0 | 42.8997274 | -98.76486568 | 2022-06-27 04:21:00 | Boyd, Nebraska, US | |
940867 | 940867 | 2022-06-25 | US | Nebraska | Boyd | 31015 | 413 | 6 | 0 | 42.8997274 | -98.76486568 | 2022-06-26 04:21:02 | Boyd, Nebraska, US | |
562249 | 562249 | 2022-06-16 | US | Washington | Garfield | 53023 | 413 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-06-17 04:20:56 | Garfield, Washington, US | |
3986051 | 3986051 | 2022-06-15 | US | Washington | Garfield | 53023 | 413 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-06-16 04:20:55 | Garfield, Washington, US | |
3727518 | 3727518 | 2022-06-07 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-08 04:20:55 | Hodgeman, Kansas, US | |
3888920 | 3888920 | 2022-06-06 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-07 04:21:08 | Hodgeman, Kansas, US | |
3508689 | 3508689 | 2022-06-05 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-06 04:20:57 | Hodgeman, Kansas, US | |
3528766 | 3528766 | 2022-06-04 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-05 04:20:55 | Hodgeman, Kansas, US | |
3134852 | 3134852 | 2022-06-03 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-04 04:20:58 | Hodgeman, Kansas, US | |
3579927 | 3579927 | 2022-06-02 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-03 04:20:58 | Hodgeman, Kansas, US | |
972220 | 972220 | 2022-06-01 | US | Kansas | Hodgeman | 20083 | 413 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-06-02 05:20:39 | Hodgeman, Kansas, US | |
1111647 | 1111647 | 2022-05-21 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-22 04:20:52 | Franklin, Nebraska, US | |
1171271 | 1171271 | 2022-05-20 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-21 04:20:58 | Franklin, Nebraska, US | |
3898034 | 3898034 | 2022-05-19 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-20 04:20:57 | Franklin, Nebraska, US | |
1186818 | 1186818 | 2022-05-18 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-19 04:20:54 | Franklin, Nebraska, US | |
3584715 | 3584715 | 2022-05-17 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-18 04:20:50 | Franklin, Nebraska, US | |
1505672 | 1505672 | 2022-05-16 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-17 04:20:59 | Franklin, Nebraska, US | |
2086031 | 2086031 | 2022-05-15 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-16 04:20:47 | Franklin, Nebraska, US | |
3356741 | 3356741 | 2022-05-14 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-15 04:20:53 | Franklin, Nebraska, US | |
660386 | 660386 | 2022-05-13 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-14 04:20:48 | Franklin, Nebraska, US | |
2535469 | 2535469 | 2022-05-12 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-13 04:20:51 | Franklin, Nebraska, US | |
3446915 | 3446915 | 2022-05-11 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-12 04:20:54 | Franklin, Nebraska, US | |
3537532 | 3537532 | 2022-05-10 | US | Nebraska | Franklin | 31061 | 413 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-05-11 04:20:48 | Franklin, Nebraska, US | |
746153 | 746153 | 2022-04-23 | China | Shanxi | 413 | 0 | 0 | 37.5777 | 112.2922 | 2022-04-24 04:20:56 | Shanxi, China | |||
3436638 | 3436638 | 2022-04-22 | China | Shanxi | 413 | 0 | 0 | 37.5777 | 112.2922 | 2022-04-23 04:20:50 | Shanxi, China | |||
3419027 | 3419027 | 2022-04-17 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-18 04:21:12 | Pawnee, Nebraska, US | |
305976 | 305976 | 2022-04-16 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-17 04:20:59 | Pawnee, Nebraska, US | |
2671921 | 2671921 | 2022-04-15 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-16 04:20:48 | Pawnee, Nebraska, US | |
1225706 | 1225706 | 2022-04-14 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-15 04:20:57 | Pawnee, Nebraska, US | |
2444864 | 2444864 | 2022-04-13 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-13 23:21:06 | Pawnee, Nebraska, US | |
1950621 | 1950621 | 2022-04-12 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-13 04:21:03 | Pawnee, Nebraska, US | |
3208374 | 3208374 | 2022-04-11 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-12 04:20:49 | Pawnee, Nebraska, US | |
1578260 | 1578260 | 2022-04-10 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-11 04:21:02 | Pawnee, Nebraska, US | |
1654502 | 1654502 | 2022-04-09 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-10 04:20:52 | Pawnee, Nebraska, US | |
2117824 | 2117824 | 2022-04-08 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-09 04:20:42 | Pawnee, Nebraska, US | |
3322348 | 3322348 | 2022-04-07 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-08 04:20:48 | Pawnee, Nebraska, US | |
2802884 | 2802884 | 2022-04-06 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-07 04:20:53 | Pawnee, Nebraska, US | |
3869653 | 3869653 | 2022-04-05 | US | Nebraska | Pawnee | 31133 | 413 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-04-06 04:20:49 | Pawnee, Nebraska, US | |
878452 | 878452 | 2022-03-27 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-28 04:20:33 | Catron, New Mexico, US | |
2165735 | 2165735 | 2022-03-26 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-27 04:20:47 | Catron, New Mexico, US | |
1722671 | 1722671 | 2022-03-25 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-26 04:20:23 | Catron, New Mexico, US | |
1470288 | 1470288 | 2022-03-24 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-25 04:20:46 | Catron, New Mexico, US | |
3024462 | 3024462 | 2022-03-23 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-24 04:20:43 | Catron, New Mexico, US | |
1907384 | 1907384 | 2022-03-22 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-23 04:20:48 | Catron, New Mexico, US | |
3240515 | 3240515 | 2022-03-21 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-22 04:20:54 | Catron, New Mexico, US | |
26588 | 26588 | 2022-03-20 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-21 04:20:50 | Catron, New Mexico, US | |
1658598 | 1658598 | 2022-03-19 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-20 04:20:45 | Catron, New Mexico, US | |
338124 | 338124 | 2022-03-18 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-19 04:20:47 | Catron, New Mexico, US | |
696577 | 696577 | 2022-03-17 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-18 04:20:55 | Catron, New Mexico, US | |
2321520 | 2321520 | 2022-03-16 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-17 04:20:56 | Catron, New Mexico, US | |
263720 | 263720 | 2022-03-15 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-16 04:20:50 | Catron, New Mexico, US | |
2266079 | 2266079 | 2022-03-14 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-15 04:20:47 | Catron, New Mexico, US | |
3630145 | 3630145 | 2022-03-13 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-14 04:20:46 | Catron, New Mexico, US | |
953053 | 953053 | 2022-03-12 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-13 04:20:49 | Catron, New Mexico, US | |
358514 | 358514 | 2022-03-11 | US | New Mexico | Catron | 35003 | 413 | 13 | 0 | 33.91514144 | -108.4046587 | 2022-03-12 04:20:50 | Catron, New Mexico, US | |
1868361 | 1868361 | 2022-03-10 | US | South Dakota | Jerauld | 46073 | 413 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-03-11 04:20:50 | Jerauld, South Dakota, US | |
3812341 | 3812341 | 2022-01-28 | US | North Dakota | Logan | 38047 | 413 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-01-29 04:21:10 | Logan, North Dakota, US | |
2054962 | 2054962 | 2022-01-25 | US | Texas | Edwards | 48137 | 413 | 10 | 0 | 29.98202582 | -100.304252 | 2022-01-26 04:21:07 | Edwards, Texas, US | |
1230693 | 1230693 | 2022-01-24 | US | Texas | Edwards | 48137 | 413 | 10 | 0 | 29.98202582 | -100.304252 | 2022-01-25 04:21:05 | Edwards, Texas, US | |
1961831 | 1961831 | 2022-01-20 | US | Kansas | Comanche | 20033 | 413 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2022-01-21 04:21:09 | Comanche, Kansas, US | |
3227726 | 3227726 | 2022-01-19 | US | Kansas | Comanche | 20033 | 413 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2022-01-20 04:21:07 | Comanche, Kansas, US | |
3466734 | 3466734 | 2022-01-18 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-19 04:21:23 | Harmon, Oklahoma, US | |
1474673 | 1474673 | 2022-01-17 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-18 04:21:04 | Harmon, Oklahoma, US | |
557347 | 557347 | 2022-01-16 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-17 04:21:08 | Harmon, Oklahoma, US | |
3843068 | 3843068 | 2022-01-15 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-16 04:21:12 | Harmon, Oklahoma, US | |
101883 | 101883 | 2022-01-14 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-15 04:21:07 | Harmon, Oklahoma, US | |
3690038 | 3690038 | 2022-01-13 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-14 04:21:54 | Harmon, Oklahoma, US | |
3615622 | 3615622 | 2022-01-12 | US | Oklahoma | Harmon | 40057 | 413 | 9 | 0 | 34.7440135 | -99.84741652 | 2022-01-13 08:00:09 | Harmon, Oklahoma, US | |
1695383 | 1695383 | 2022-01-10 | US | Texas | Culberson | 48109 | 413 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-01-11 04:22:01 | Culberson, Texas, US | |
1288055 | 1288055 | 2022-01-04 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-01-05 04:21:59 | Brown, Nebraska, US | |
1702399 | 1702399 | 2022-01-03 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-01-04 04:22:17 | Brown, Nebraska, US | |
3521482 | 3521482 | 2022-01-02 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-01-03 02:22:25 | Brown, Nebraska, US | |
2169612 | 2169612 | 2022-01-01 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-01-02 04:20:52 | Brown, Nebraska, US | |
2779043 | 2779043 | 2021-12-31 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-01-01 04:22:14 | Brown, Nebraska, US | |
4000700 | 4000700 | 2021-12-30 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-31 04:21:50 | Brown, Nebraska, US | |
1670507 | 1670507 | 2021-12-29 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-30 04:21:25 | Brown, Nebraska, US | |
1433501 | 1433501 | 2021-12-28 | US | Idaho | Custer | 16037 | 413 | 6 | 0 | 44.24186819 | -114.2855494 | 2021-12-29 03:21:43 | Custer, Idaho, US | |
733544 | 733544 | 2021-12-27 | US | Texas | Armstrong | 48011 | 413 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-28 04:21:47 | Armstrong, Texas, US | |
731462 | 731462 | 2021-12-27 | US | Idaho | Custer | 16037 | 413 | 6 | 0 | 44.24186819 | -114.2855494 | 2021-12-28 04:21:47 | Custer, Idaho, US | |
2114716 | 2114716 | 2021-12-26 | US | Texas | Armstrong | 48011 | 413 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-27 04:21:58 | Armstrong, Texas, US | |
800479 | 800479 | 2021-12-22 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-23 04:21:21 | Brown, Nebraska, US | |
3830519 | 3830519 | 2021-12-21 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-22 04:21:54 | Brown, Nebraska, US | |
1256822 | 1256822 | 2021-12-20 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-21 03:21:27 | Brown, Nebraska, US | |
2905765 | 2905765 | 2021-12-19 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-20 04:21:43 | Brown, Nebraska, US | |
1260838 | 1260838 | 2021-12-18 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-19 04:21:11 | Brown, Nebraska, US | |
2400866 | 2400866 | 2021-12-17 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-18 02:22:20 | Brown, Nebraska, US | |
1718404 | 1718404 | 2021-12-16 | US | Nebraska | Brown | 31017 | 413 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-17 04:22:14 | Brown, Nebraska, US | |
1717163 | 1717163 | 2021-12-16 | US | Georgia | Glascock | 13125 | 413 | 21 | 0 | 33.22879932 | -82.61297636 | 2021-12-17 04:22:14 | Glascock, Georgia, US | |
3496997 | 3496997 | 2021-12-15 | US | Georgia | Glascock | 13125 | 413 | 21 | 0 | 33.22879932 | -82.61297636 | 2021-12-16 04:22:11 | Glascock, Georgia, US | |
3232 | 3232 | 2021-12-02 | US | South Dakota | Sanborn | 46111 | 413 | 3 | 0 | 44.02351092 | -98.09098159999999 | 2021-12-03 04:23:05 | Sanborn, South Dakota, US | |
118 | 118 | 2021-12-02 | China | Guangxi | 413 | 2 | 0 | 23.8298 | 108.7881 | 2021-12-03 04:23:05 | Guangxi, China |
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]);