johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
729 rows where confirmed = 479 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379771 | 3379771 | 2022-12-08 | US | North Dakota | Burke | 38013 | 479 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-09 04:21:05 | Burke, North Dakota, US | |
1621577 | 1621577 | 2022-11-22 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-23 04:21:06 | Hodgeman, Kansas, US | |
3461465 | 3461465 | 2022-11-21 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-22 04:20:47 | Hodgeman, Kansas, US | |
1641650 | 1641650 | 2022-11-20 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-21 04:21:05 | Hodgeman, Kansas, US | |
2065207 | 2065207 | 2022-11-19 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-20 04:21:08 | Hodgeman, Kansas, US | |
1756601 | 1756601 | 2022-11-18 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-19 04:21:14 | Hodgeman, Kansas, US | |
3027594 | 3027594 | 2022-11-17 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-18 04:21:15 | Hodgeman, Kansas, US | |
2487305 | 2487305 | 2022-11-16 | US | Kansas | Hodgeman | 20083 | 479 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-17 04:21:11 | Hodgeman, Kansas, US | |
1832265 | 1832265 | 2022-10-25 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-26 04:22:19 | Pawnee, Nebraska, US | |
796526 | 796526 | 2022-10-24 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-25 04:21:53 | Pawnee, Nebraska, US | |
3278981 | 3278981 | 2022-10-23 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-24 04:22:29 | Pawnee, Nebraska, US | |
2270019 | 2270019 | 2022-10-22 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-23 04:22:46 | Pawnee, Nebraska, US | |
1594319 | 1594319 | 2022-10-21 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-22 04:22:53 | Pawnee, Nebraska, US | |
2274035 | 2274035 | 2022-10-20 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-21 04:22:23 | Pawnee, Nebraska, US | |
200370 | 200370 | 2022-10-19 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-20 04:22:59 | Pawnee, Nebraska, US | |
2759031 | 2759031 | 2022-10-18 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-19 04:22:26 | Pawnee, Nebraska, US | |
2026865 | 2026865 | 2022-10-17 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-18 04:22:42 | Pawnee, Nebraska, US | |
2161643 | 2161643 | 2022-10-16 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-17 04:20:31 | Pawnee, Nebraska, US | |
517840 | 517840 | 2022-10-15 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-16 04:22:39 | Pawnee, Nebraska, US | |
2034897 | 2034897 | 2022-10-14 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-15 04:22:00 | Pawnee, Nebraska, US | |
3755585 | 3755585 | 2022-10-13 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-14 04:22:28 | Pawnee, Nebraska, US | |
3216410 | 3216410 | 2022-10-12 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-13 04:22:39 | Pawnee, Nebraska, US | |
3252339 | 3252339 | 2022-10-11 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-12 04:22:51 | Catron, New Mexico, US | |
3252259 | 3252259 | 2022-10-11 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-12 04:22:51 | Pawnee, Nebraska, US | |
2969598 | 2969598 | 2022-10-10 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-11 04:23:05 | Catron, New Mexico, US | |
2969518 | 2969518 | 2022-10-10 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-11 04:23:05 | Pawnee, Nebraska, US | |
3099634 | 3099634 | 2022-10-09 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-10 04:22:32 | Catron, New Mexico, US | |
3099554 | 3099554 | 2022-10-09 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-10 04:22:32 | Pawnee, Nebraska, US | |
4004859 | 4004859 | 2022-10-08 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-09 04:21:16 | Catron, New Mexico, US | |
4004779 | 4004779 | 2022-10-08 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-09 04:21:16 | Pawnee, Nebraska, US | |
398456 | 398456 | 2022-10-07 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-08 04:22:56 | Catron, New Mexico, US | |
398376 | 398376 | 2022-10-07 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-08 04:22:56 | Pawnee, Nebraska, US | |
2531573 | 2531573 | 2022-10-06 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-07 04:23:08 | Catron, New Mexico, US | |
2531493 | 2531493 | 2022-10-06 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-07 04:23:08 | Pawnee, Nebraska, US | |
1812967 | 1812967 | 2022-10-05 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-06 04:21:22 | Catron, New Mexico, US | |
1812887 | 1812887 | 2022-10-05 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-06 04:21:22 | Pawnee, Nebraska, US | |
132941 | 132941 | 2022-10-04 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-05 04:23:06 | Catron, New Mexico, US | |
132861 | 132861 | 2022-10-04 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-05 04:23:06 | Pawnee, Nebraska, US | |
2687888 | 2687888 | 2022-10-03 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-04 04:22:55 | Catron, New Mexico, US | |
2687808 | 2687808 | 2022-10-03 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-04 04:22:55 | Pawnee, Nebraska, US | |
2261955 | 2261955 | 2022-10-02 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-03 04:23:11 | Catron, New Mexico, US | |
2261875 | 2261875 | 2022-10-02 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-03 04:23:11 | Pawnee, Nebraska, US | |
2997481 | 2997481 | 2022-10-01 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-02 04:21:23 | Catron, New Mexico, US | |
2997401 | 2997401 | 2022-10-01 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-02 04:21:23 | Pawnee, Nebraska, US | |
855807 | 855807 | 2022-09-30 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-01 04:23:01 | Catron, New Mexico, US | |
855727 | 855727 | 2022-09-30 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-10-01 04:23:01 | Pawnee, Nebraska, US | |
2377733 | 2377733 | 2022-09-29 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-30 04:23:09 | Catron, New Mexico, US | |
2377653 | 2377653 | 2022-09-29 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-30 04:23:09 | Pawnee, Nebraska, US | |
1562284 | 1562284 | 2022-09-28 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-29 04:22:34 | Catron, New Mexico, US | |
1562204 | 1562204 | 2022-09-28 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-29 04:22:34 | Pawnee, Nebraska, US | |
3996827 | 3996827 | 2022-09-27 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-28 04:23:01 | Catron, New Mexico, US | |
3996747 | 3996747 | 2022-09-27 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-28 04:23:01 | Pawnee, Nebraska, US | |
2771075 | 2771075 | 2022-09-26 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-27 04:23:01 | Pawnee, Nebraska, US | |
1978808 | 1978808 | 2022-09-25 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-26 04:20:52 | Catron, New Mexico, US | |
1978728 | 1978728 | 2022-09-25 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-26 04:20:52 | Pawnee, Nebraska, US | |
2651975 | 2651975 | 2022-09-24 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-25 04:23:31 | Catron, New Mexico, US | |
2651895 | 2651895 | 2022-09-24 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-25 04:23:31 | Pawnee, Nebraska, US | |
386415 | 386415 | 2022-09-23 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-24 04:21:40 | Catron, New Mexico, US | |
386335 | 386335 | 2022-09-23 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-24 04:21:40 | Pawnee, Nebraska, US | |
1626481 | 1626481 | 2022-09-22 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-23 04:23:13 | Catron, New Mexico, US | |
1626401 | 1626401 | 2022-09-22 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-23 04:23:13 | Pawnee, Nebraska, US | |
1372685 | 1372685 | 2022-09-21 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-22 04:22:56 | Catron, New Mexico, US | |
1372605 | 1372605 | 2022-09-21 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-22 04:22:56 | Pawnee, Nebraska, US | |
2018915 | 2018915 | 2022-09-20 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-21 04:23:22 | Catron, New Mexico, US | |
2018835 | 2018835 | 2022-09-20 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-21 04:23:22 | Pawnee, Nebraska, US | |
3572708 | 3572708 | 2022-09-19 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-20 04:22:48 | Pawnee, Nebraska, US | |
421447 | 421447 | 2022-09-18 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-19 04:21:49 | Pawnee, Nebraska, US | |
3375471 | 3375471 | 2022-09-17 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-18 04:22:50 | Pawnee, Nebraska, US | |
2357579 | 2357579 | 2022-09-16 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-17 04:20:19 | Pawnee, Nebraska, US | |
3988736 | 3988736 | 2022-09-15 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-16 04:21:19 | Pawnee, Nebraska, US | |
1891253 | 1891253 | 2022-09-14 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-15 04:21:02 | Pawnee, Nebraska, US | |
374308 | 374308 | 2022-09-13 | US | Nebraska | Pawnee | 31133 | 479 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-09-14 04:20:44 | Pawnee, Nebraska, US | |
3747300 | 3747300 | 2022-09-07 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-08 04:21:02 | Catron, New Mexico, US | |
116940 | 116940 | 2022-09-06 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-07 04:20:59 | Catron, New Mexico, US | |
2635912 | 2635912 | 2022-09-05 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-06 04:21:02 | Catron, New Mexico, US | |
2989476 | 2989476 | 2022-09-04 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-05 04:21:01 | Catron, New Mexico, US | |
2715161 | 2715161 | 2022-09-03 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-04 04:21:22 | Catron, New Mexico, US | |
1395866 | 1395866 | 2022-09-02 | US | New Mexico | Catron | 35003 | 479 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-03 04:21:04 | Catron, New Mexico, US | |
3546565 | 3546565 | 2022-08-08 | US | Texas | Dickens | 48125 | 479 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-09 04:20:34 | Dickens, Texas, US | |
1072968 | 1072968 | 2022-08-07 | US | Texas | Dickens | 48125 | 479 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-08 04:21:08 | Dickens, Texas, US | |
1943556 | 1943556 | 2022-08-06 | US | Texas | Dickens | 48125 | 479 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-07 04:20:54 | Dickens, Texas, US | |
883355 | 883355 | 2022-08-05 | US | Texas | Dickens | 48125 | 479 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-06 04:20:56 | Dickens, Texas, US | |
2011766 | 2011766 | 2022-08-04 | US | Texas | Dickens | 48125 | 479 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-05 04:20:52 | Dickens, Texas, US | |
3212687 | 3212687 | 2022-07-18 | US | North Dakota | Grant | 38037 | 479 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-19 04:20:58 | Grant, North Dakota, US | |
3407862 | 3407862 | 2022-07-17 | US | North Dakota | Grant | 38037 | 479 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-18 04:20:59 | Grant, North Dakota, US | |
2154692 | 2154692 | 2022-07-16 | US | Texas | Briscoe | 48045 | 479 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-17 04:21:15 | Briscoe, Texas, US | |
2154062 | 2154062 | 2022-07-16 | US | North Dakota | Grant | 38037 | 479 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-17 04:21:15 | Grant, North Dakota, US | |
2421925 | 2421925 | 2022-07-15 | US | Texas | Briscoe | 48045 | 479 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-16 04:21:05 | Briscoe, Texas, US | |
2421295 | 2421295 | 2022-07-15 | US | North Dakota | Grant | 38037 | 479 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-16 04:21:05 | Grant, North Dakota, US | |
3081191 | 3081191 | 2022-07-04 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-05 04:20:45 | Irion, Texas, US | |
1770473 | 1770473 | 2022-07-03 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-04 04:20:54 | Irion, Texas, US | |
3368459 | 3368459 | 2022-07-02 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-03 04:20:59 | Irion, Texas, US | |
596788 | 596788 | 2022-07-01 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-02 04:21:16 | Irion, Texas, US | |
3943189 | 3943189 | 2022-06-30 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-01 04:21:10 | Irion, Texas, US | |
2493147 | 2493147 | 2022-06-29 | US | Texas | Irion | 48235 | 479 | 3 | 0 | 31.30375559 | -100.982439 | 2022-06-30 04:21:01 | Irion, Texas, US | |
2241802 | 2241802 | 2022-06-28 | US | North Dakota | Golden Valley | 38033 | 479 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-29 04:20:59 | Golden Valley, North Dakota, US | |
2150044 | 2150044 | 2022-06-27 | US | North Dakota | Golden Valley | 38033 | 479 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-28 04:20:58 | Golden Valley, North Dakota, US | |
477845 | 477845 | 2022-06-26 | US | North Dakota | Golden Valley | 38033 | 479 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-27 04:21:00 | Golden Valley, North Dakota, US | |
941220 | 941220 | 2022-06-25 | US | North Dakota | Golden Valley | 38033 | 479 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-26 04:21:02 | Golden Valley, North Dakota, US | |
3349040 | 3349040 | 2022-06-24 | US | North Dakota | Golden Valley | 38033 | 479 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-25 04:20:57 | Golden Valley, North Dakota, 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]);