johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
729 rows where confirmed = 566 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2275056 | 2275056 | 2022-10-20 | US | Texas | Irion | 48235 | 566 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-21 04:22:23 | Irion, Texas, US | |
201391 | 201391 | 2022-10-19 | US | Texas | Irion | 48235 | 566 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-20 04:22:59 | Irion, Texas, US | |
2831965 | 2831965 | 2022-08-25 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-26 04:21:02 | Knox, Texas, US | |
2326498 | 2326498 | 2022-08-24 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-25 04:21:13 | Knox, Texas, US | |
1253907 | 1253907 | 2022-08-23 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-24 04:20:46 | Knox, Texas, US | |
2856011 | 2856011 | 2022-08-22 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-23 04:20:56 | Knox, Texas, US | |
2405983 | 2405983 | 2022-08-21 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-22 04:20:38 | Knox, Texas, US | |
3801061 | 3801061 | 2022-08-20 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-21 04:20:44 | Knox, Texas, US | |
2366647 | 2366647 | 2022-08-19 | US | Texas | Knox | 48275 | 566 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-08-20 04:21:01 | Knox, Texas, US | |
673475 | 673475 | 2022-07-21 | US | Texas | Menard | 48327 | 566 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-07-22 04:21:15 | Menard, Texas, US | |
1611438 | 1611438 | 2022-07-20 | US | Texas | Menard | 48327 | 566 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-07-21 04:21:10 | Menard, Texas, US | |
960178 | 960178 | 2022-07-19 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-20 04:20:59 | Edwards, Kansas, US | |
3211565 | 3211565 | 2022-07-18 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-19 04:20:58 | Edwards, Kansas, US | |
3406740 | 3406740 | 2022-07-17 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-18 04:20:59 | Edwards, Kansas, US | |
2152940 | 2152940 | 2022-07-16 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-17 04:21:15 | Edwards, Kansas, US | |
2420173 | 2420173 | 2022-07-15 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-16 04:21:05 | Edwards, Kansas, US | |
3430248 | 3430248 | 2022-07-14 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-15 04:20:53 | Edwards, Kansas, US | |
3110768 | 3110768 | 2022-07-13 | US | Kansas | Edwards | 20047 | 566 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-14 04:20:57 | Edwards, Kansas, US | |
1214663 | 1214663 | 2022-07-11 | US | Texas | Hardeman | 48197 | 566 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-07-12 04:20:51 | Hardeman, Texas, US | |
2792145 | 2792145 | 2022-07-10 | US | Texas | Hardeman | 48197 | 566 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-07-11 04:20:46 | Hardeman, Texas, US | |
145098 | 145098 | 2022-07-09 | US | Texas | Hardeman | 48197 | 566 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-07-10 04:20:54 | Hardeman, Texas, US | |
1416890 | 1416890 | 2022-07-08 | China | Macau | 566 | 2 | 0 | 22.1667 | 113.55 | 2022-07-09 04:20:59 | Macau, China | |||
3349655 | 3349655 | 2022-06-24 | US | Texas | Armstrong | 48011 | 566 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-06-25 04:20:57 | Armstrong, Texas, US | |
1651396 | 1651396 | 2022-06-23 | US | Texas | Armstrong | 48011 | 566 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-06-24 04:20:58 | Armstrong, Texas, US | |
1649314 | 1649314 | 2022-06-23 | US | Idaho | Custer | 16037 | 566 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-06-24 04:20:58 | Custer, Idaho, US | |
2188549 | 2188549 | 2022-06-22 | US | Idaho | Custer | 16037 | 566 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-06-23 04:20:55 | Custer, Idaho, US | |
950041 | 950041 | 2022-06-14 | US | Texas | Oldham | 48359 | 566 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-06-15 04:20:54 | Oldham, Texas, US | |
949273 | 949273 | 2022-06-14 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-15 04:20:54 | Renville, North Dakota, US | |
2982449 | 2982449 | 2022-06-13 | US | Texas | Oldham | 48359 | 566 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-06-14 04:20:52 | Oldham, Texas, US | |
2981681 | 2981681 | 2022-06-13 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-14 04:20:52 | Renville, North Dakota, US | |
2237807 | 2237807 | 2022-06-12 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-13 04:21:14 | Renville, North Dakota, US | |
3144005 | 3144005 | 2022-06-11 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-12 04:20:53 | Renville, North Dakota, US | |
1946921 | 1946921 | 2022-06-10 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-11 04:21:01 | Renville, North Dakota, US | |
3160060 | 3160060 | 2022-06-09 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-10 04:20:55 | Renville, North Dakota, US | |
1423527 | 1423527 | 2022-06-08 | US | North Dakota | Renville | 38075 | 566 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-06-09 04:20:54 | Renville, North Dakota, US | |
2050410 | 2050410 | 2022-05-25 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-26 04:20:50 | Cimarron, Oklahoma, US | |
3001848 | 3001848 | 2022-05-24 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-25 04:20:56 | Cimarron, Oklahoma, US | |
3595569 | 3595569 | 2022-05-23 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-24 04:20:57 | Cimarron, Oklahoma, US | |
624421 | 624421 | 2022-05-22 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-26 04:20:50 | Cimarron, Oklahoma, US | |
1112117 | 1112117 | 2022-05-21 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-22 04:20:52 | Cimarron, Oklahoma, US | |
1171741 | 1171741 | 2022-05-20 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-21 04:20:58 | Cimarron, Oklahoma, US | |
3898504 | 3898504 | 2022-05-19 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-20 04:20:57 | Cimarron, Oklahoma, US | |
1187288 | 1187288 | 2022-05-18 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-19 04:20:54 | Cimarron, Oklahoma, US | |
3585185 | 3585185 | 2022-05-17 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-18 04:20:50 | Cimarron, Oklahoma, US | |
1506142 | 1506142 | 2022-05-16 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-17 04:20:59 | Cimarron, Oklahoma, US | |
2086501 | 2086501 | 2022-05-15 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-16 04:20:47 | Cimarron, Oklahoma, US | |
3357211 | 3357211 | 2022-05-14 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-15 04:20:53 | Cimarron, Oklahoma, US | |
660856 | 660856 | 2022-05-13 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-14 04:20:48 | Cimarron, Oklahoma, US | |
2535939 | 2535939 | 2022-05-12 | US | Oklahoma | Cimarron | 40025 | 566 | 7 | 0 | 36.74817177 | -102.5173885 | 2022-05-13 04:20:51 | Cimarron, Oklahoma, US | |
2893705 | 2893705 | 2022-04-21 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-22 04:20:45 | Graham, Kansas, US | |
2308577 | 2308577 | 2022-04-20 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-21 04:20:46 | Graham, Kansas, US | |
2252716 | 2252716 | 2022-04-19 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-20 04:20:45 | Graham, Kansas, US | |
1847266 | 1847266 | 2022-04-18 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-19 04:21:00 | Graham, Kansas, US | |
3418210 | 3418210 | 2022-04-17 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-18 04:21:12 | Graham, Kansas, US | |
305159 | 305159 | 2022-04-16 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-17 04:20:59 | Graham, Kansas, US | |
2671104 | 2671104 | 2022-04-15 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-16 04:20:48 | Graham, Kansas, US | |
1224889 | 1224889 | 2022-04-14 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-13 23:21:06 | Graham, Kansas, US | |
2444047 | 2444047 | 2022-04-13 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-13 23:21:06 | Graham, Kansas, US | |
1949804 | 1949804 | 2022-04-12 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-13 04:21:03 | Graham, Kansas, US | |
3207557 | 3207557 | 2022-04-11 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-12 04:20:49 | Graham, Kansas, US | |
1577443 | 1577443 | 2022-04-10 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-11 04:21:02 | Graham, Kansas, US | |
1653685 | 1653685 | 2022-04-09 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-10 04:20:52 | Graham, Kansas, US | |
2117007 | 2117007 | 2022-04-08 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-09 04:20:42 | Graham, Kansas, US | |
3321531 | 3321531 | 2022-04-07 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-08 04:20:48 | Graham, Kansas, US | |
2802067 | 2802067 | 2022-04-06 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-07 04:20:53 | Graham, Kansas, US | |
3868836 | 3868836 | 2022-04-05 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-06 04:20:49 | Graham, Kansas, US | |
2751292 | 2751292 | 2022-04-04 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-04-05 04:20:48 | Griggs, North Dakota, US | |
2750178 | 2750178 | 2022-04-04 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-05 04:20:48 | Graham, Kansas, US | |
3732638 | 3732638 | 2022-04-03 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-04-04 04:20:51 | Griggs, North Dakota, US | |
3731524 | 3731524 | 2022-04-03 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-04 04:20:51 | Graham, Kansas, US | |
502073 | 502073 | 2022-04-02 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-04-03 04:20:48 | Griggs, North Dakota, US | |
500959 | 500959 | 2022-04-02 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-03 04:20:48 | Graham, Kansas, US | |
3353058 | 3353058 | 2022-04-01 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-04-02 04:20:47 | Griggs, North Dakota, US | |
3351944 | 3351944 | 2022-04-01 | US | Kansas | Graham | 20065 | 566 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-04-02 04:20:47 | Graham, Kansas, US | |
1542363 | 1542363 | 2022-03-31 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-04-01 04:20:28 | Griggs, North Dakota, US | |
1541249 | 1541249 | 2022-03-31 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-04-01 04:20:28 | Graham, Kansas, US | |
2480376 | 2480376 | 2022-03-30 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-31 04:20:56 | Griggs, North Dakota, US | |
2479262 | 2479262 | 2022-03-30 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-31 04:20:56 | Graham, Kansas, US | |
160417 | 160417 | 2022-03-29 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-30 04:20:45 | Griggs, North Dakota, US | |
159303 | 159303 | 2022-03-29 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-30 04:20:45 | Graham, Kansas, US | |
1438988 | 1438988 | 2022-03-28 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-29 04:20:46 | Griggs, North Dakota, US | |
1437874 | 1437874 | 2022-03-28 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-29 04:20:46 | Graham, Kansas, US | |
878669 | 878669 | 2022-03-27 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-28 04:20:33 | Griggs, North Dakota, US | |
877555 | 877555 | 2022-03-27 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-28 04:20:33 | Graham, Kansas, US | |
2165952 | 2165952 | 2022-03-26 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-27 04:20:47 | Griggs, North Dakota, US | |
2164838 | 2164838 | 2022-03-26 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-27 04:20:47 | Graham, Kansas, US | |
1722888 | 1722888 | 2022-03-25 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-26 04:20:23 | Griggs, North Dakota, US | |
1721774 | 1721774 | 2022-03-25 | US | Kansas | Graham | 20065 | 566 | 14 | 0 | 39.34987223 | -99.88332493 | 2022-03-26 04:20:23 | Graham, Kansas, US | |
1470505 | 1470505 | 2022-03-24 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-25 04:20:46 | Griggs, North Dakota, US | |
3024679 | 3024679 | 2022-03-23 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-24 04:20:43 | Griggs, North Dakota, US | |
1907601 | 1907601 | 2022-03-22 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-23 04:20:48 | Griggs, North Dakota, US | |
3240732 | 3240732 | 2022-03-21 | US | North Dakota | Griggs | 38039 | 566 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-03-22 04:20:54 | Griggs, North Dakota, US | |
2527558 | 2527558 | 2022-03-02 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-03-03 04:21:01 | De Baca, New Mexico, US | |
1994852 | 1994852 | 2022-03-01 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-03-02 04:21:07 | De Baca, New Mexico, US | |
945026 | 945026 | 2022-02-28 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-03-01 04:21:09 | De Baca, New Mexico, US | |
2735217 | 2735217 | 2022-02-27 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-02-28 04:21:05 | De Baca, New Mexico, US | |
3048370 | 3048370 | 2022-02-26 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-02-27 04:21:04 | De Baca, New Mexico, US | |
577025 | 577025 | 2022-02-25 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-02-26 04:21:12 | De Baca, New Mexico, US | |
1513601 | 1513601 | 2022-02-24 | US | New Mexico | De Baca | 35011 | 566 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-02-25 04:21:11 | De Baca, New Mexico, US | |
1512691 | 1512691 | 2022-02-24 | US | Kansas | Elk | 20049 | 566 | 8 | 0 | 37.45338105 | -96.24369667 | 2022-02-25 04:21:11 | Elk, Kansas, 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]);