johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
289 rows where confirmed = 2829 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310210 | 310210 | 2022-12-13 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-14 04:21:04 | Graham, North Carolina, US | |
1151271 | 1151271 | 2022-12-12 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-13 04:21:01 | Graham, North Carolina, US | |
871125 | 871125 | 2022-12-11 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-12 04:21:01 | Graham, North Carolina, US | |
259655 | 259655 | 2022-12-10 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-11 04:20:50 | Graham, North Carolina, US | |
3938369 | 3938369 | 2022-12-09 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-10 04:21:02 | Graham, North Carolina, US | |
3379701 | 3379701 | 2022-12-08 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-09 04:21:05 | Graham, North Carolina, US | |
1986972 | 1986972 | 2022-12-07 | US | North Carolina | Graham | 37075 | 2829 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-08 04:21:07 | Graham, North Carolina, US | |
3555054 | 3555054 | 2022-11-27 | US | Virginia | Richmond | 51159 | 2829 | 27 | 0 | 37.937575 | -76.72920628 | 2022-11-28 04:21:02 | Richmond, Virginia, US | |
2103534 | 2103534 | 2022-11-26 | US | Virginia | Richmond | 51159 | 2829 | 27 | 0 | 37.937575 | -76.72920628 | 2022-11-27 04:21:05 | Richmond, Virginia, US | |
491025 | 491025 | 2022-11-25 | US | Virginia | Richmond | 51159 | 2829 | 27 | 0 | 37.937575 | -76.72920628 | 2022-11-26 04:21:11 | Richmond, Virginia, US | |
3526854 | 3526854 | 2022-11-24 | US | Virginia | Richmond | 51159 | 2829 | 27 | 0 | 37.937575 | -76.72920628 | 2022-11-25 04:21:06 | Richmond, Virginia, US | |
3315637 | 3315637 | 2022-11-23 | US | Virginia | Richmond | 51159 | 2829 | 27 | 0 | 37.937575 | -76.72920628 | 2022-11-24 04:21:09 | Richmond, Virginia, US | |
3312753 | 3312753 | 2022-11-23 | US | Arkansas | Pike | 5109 | 2829 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-11-24 04:21:09 | Pike, Arkansas, US | |
1833206 | 1833206 | 2022-10-25 | US | Texas | Childress | 48075 | 2829 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-10-26 04:22:19 | Childress, Texas, US | |
797467 | 797467 | 2022-10-24 | US | Texas | Childress | 48075 | 2829 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-10-25 04:21:53 | Childress, Texas, US | |
1372911 | 1372911 | 2022-09-21 | US | North Dakota | Mercer | 38057 | 2829 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-09-22 04:22:56 | Mercer, North Dakota, US | |
3766958 | 3766958 | 2022-09-11 | US | Indiana | Crawford | 18025 | 2829 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-09-12 04:20:58 | Crawford, Indiana, US | |
3825533 | 3825533 | 2022-09-10 | US | Indiana | Crawford | 18025 | 2829 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-09-11 04:20:50 | Crawford, Indiana, US | |
963990 | 963990 | 2022-09-09 | US | Indiana | Crawford | 18025 | 2829 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-09-10 04:21:10 | Crawford, Indiana, US | |
1164125 | 1164125 | 2022-08-18 | US | Tennessee | Houston | 47083 | 2829 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-08-19 04:20:54 | Houston, Tennessee, US | |
3648234 | 3648234 | 2022-08-14 | US | Colorado | Prowers | 8099 | 2829 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-08-15 04:20:59 | Prowers, Colorado, US | |
1969240 | 1969240 | 2022-08-13 | US | Colorado | Prowers | 8099 | 2829 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-08-14 04:20:55 | Prowers, Colorado, US | |
3618711 | 3618711 | 2022-08-01 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-08-02 04:20:53 | Crawford, Michigan, US | |
3873191 | 3873191 | 2022-07-31 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-08-01 04:21:03 | Crawford, Michigan, US | |
675945 | 675945 | 2022-07-30 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-07-31 04:21:02 | Crawford, Michigan, US | |
1785144 | 1785144 | 2022-07-29 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-07-30 04:20:42 | Crawford, Michigan, US | |
1067507 | 1067507 | 2022-07-28 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-07-29 04:20:45 | Crawford, Michigan, US | |
2337026 | 2337026 | 2022-07-27 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-07-28 04:20:56 | Crawford, Michigan, US | |
2335203 | 2335203 | 2022-07-27 | China | Shandong | 2829 | 7 | 0 | 36.3427 | 118.1498 | 2022-07-28 04:20:56 | Shandong, China | |||
1489216 | 1489216 | 2022-07-26 | US | Michigan | Crawford | 26039 | 2829 | 34 | 0 | 44.68255561 | -84.61006219 | 2022-07-27 04:21:04 | Crawford, Michigan, US | |
962275 | 962275 | 2022-07-19 | US | Virginia | Nelson | 51125 | 2829 | 36 | 0 | 37.78790447 | -78.88498513 | 2022-07-20 04:20:59 | Nelson, Virginia, US | |
3213517 | 3213517 | 2022-07-18 | US | Texas | Terry | 48445 | 2829 | 85 | 0 | 33.17402785 | -102.3354521 | 2022-07-19 04:20:58 | Terry, Texas, US | |
3405845 | 3405845 | 2022-07-17 | US | Alabama | Lowndes | 1085 | 2829 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-18 04:20:59 | Lowndes, Alabama, US | |
2152045 | 2152045 | 2022-07-16 | US | Alabama | Lowndes | 1085 | 2829 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-17 04:21:15 | Lowndes, Alabama, US | |
2419278 | 2419278 | 2022-07-15 | US | Alabama | Lowndes | 1085 | 2829 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-16 04:21:05 | Lowndes, Alabama, US | |
2791997 | 2791997 | 2022-07-10 | US | Tennessee | Lake | 47095 | 2829 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-07-11 04:20:46 | Lake, Tennessee, US | |
144950 | 144950 | 2022-07-09 | US | Tennessee | Lake | 47095 | 2829 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-07-10 04:20:54 | Lake, Tennessee, US | |
1420050 | 1420050 | 2022-07-08 | US | Tennessee | Lake | 47095 | 2829 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-07-09 04:20:59 | Lake, Tennessee, US | |
3943257 | 3943257 | 2022-06-30 | US | Texas | Pecos | 48371 | 2829 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-07-01 04:21:10 | Pecos, Texas, US | |
2493215 | 2493215 | 2022-06-29 | US | Texas | Pecos | 48371 | 2829 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-06-30 04:21:01 | Pecos, Texas, US | |
3159561 | 3159561 | 2022-06-09 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-10 04:20:55 | Lewis, Missouri, US | |
1423028 | 1423028 | 2022-06-08 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-09 04:20:54 | Lewis, Missouri, US | |
3728142 | 3728142 | 2022-06-07 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-08 04:20:55 | Lewis, Missouri, US | |
3889544 | 3889544 | 2022-06-06 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-07 04:21:08 | Lewis, Missouri, US | |
3509313 | 3509313 | 2022-06-05 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-06 04:20:57 | Lewis, Missouri, US | |
3529390 | 3529390 | 2022-06-04 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-05 04:20:55 | Lewis, Missouri, US | |
3135476 | 3135476 | 2022-06-03 | US | Missouri | Lewis | 29111 | 2829 | 42 | 0 | 40.09673161 | -91.72070156 | 2022-06-04 04:20:58 | Lewis, Missouri, US | |
3000618 | 3000618 | 2022-05-24 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-25 04:20:56 | Linn, Kansas, US | |
3594339 | 3594339 | 2022-05-23 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-24 04:20:57 | Linn, Kansas, US | |
1110887 | 1110887 | 2022-05-21 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-22 04:20:52 | Linn, Kansas, US | |
1170511 | 1170511 | 2022-05-20 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-21 04:20:58 | Linn, Kansas, US | |
3897274 | 3897274 | 2022-05-19 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-20 04:20:57 | Linn, Kansas, US | |
1186058 | 1186058 | 2022-05-18 | US | Kansas | Linn | 20107 | 2829 | 32 | 0 | 38.21267844 | -94.84254089 | 2022-05-19 04:20:54 | Linn, Kansas, US | |
661392 | 661392 | 2022-05-13 | US | Texas | Eastland | 48133 | 2829 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-14 04:20:48 | Eastland, Texas, US | |
3448093 | 3448093 | 2022-05-11 | US | Texas | Ward | 48475 | 2829 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-05-12 04:20:54 | Ward, Texas, US | |
3538710 | 3538710 | 2022-05-10 | US | Texas | Ward | 48475 | 2829 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-05-11 04:20:48 | Ward, Texas, US | |
225245 | 225245 | 2022-05-09 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-10 04:20:50 | Ward, Texas, US | |
2334630 | 2334630 | 2022-05-08 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-09 04:20:54 | Ward, Texas, US | |
363592 | 363592 | 2022-05-07 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-08 04:20:49 | Ward, Texas, US | |
1400943 | 1400943 | 2022-05-06 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-07 04:21:09 | Ward, Texas, US | |
2601298 | 2601298 | 2022-05-05 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-06 04:21:00 | Ward, Texas, US | |
3268747 | 3268747 | 2022-05-04 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-05 04:20:55 | Ward, Texas, US | |
3267699 | 3267699 | 2022-05-04 | US | New Mexico | Los Alamos | 35028 | 2829 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-05-05 04:20:55 | Los Alamos, New Mexico, US | |
1575386 | 1575386 | 2022-05-03 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-04 04:20:59 | Ward, Texas, US | |
466646 | 466646 | 2022-05-02 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-03 04:21:00 | Ward, Texas, US | |
3919285 | 3919285 | 2022-05-01 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-02 04:21:10 | Ward, Texas, US | |
2844089 | 2844089 | 2022-04-30 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-05-01 04:20:57 | Ward, Texas, US | |
1160402 | 1160402 | 2022-04-29 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-04-30 04:21:05 | Ward, Texas, US | |
1699584 | 1699584 | 2022-04-28 | US | Texas | Ward | 48475 | 2829 | 43 | 0 | 31.50999644 | -103.0927909 | 2022-04-29 04:20:59 | Ward, Texas, US | |
3420285 | 3420285 | 2022-04-17 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-04-18 04:21:12 | Lexington, Virginia, US | |
307234 | 307234 | 2022-04-16 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-04-17 04:20:59 | Lexington, Virginia, US | |
2673179 | 2673179 | 2022-04-15 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-04-16 04:20:48 | Lexington, Virginia, US | |
1539752 | 1539752 | 2022-03-31 | China | Henan | 2829 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-04-01 04:20:28 | Henan, China | |||
2477765 | 2477765 | 2022-03-30 | China | Henan | 2829 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-31 04:20:56 | Henan, China | |||
879630 | 879630 | 2022-03-27 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-03-28 04:20:33 | Lexington, Virginia, US | |
2166913 | 2166913 | 2022-03-26 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-03-27 04:20:47 | Lexington, Virginia, US | |
1723849 | 1723849 | 2022-03-25 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-03-26 04:20:23 | Lexington, Virginia, US | |
1471466 | 1471466 | 2022-03-24 | US | Virginia | Lexington | 51678 | 2829 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-03-25 04:20:46 | Lexington, Virginia, US | |
1469973 | 1469973 | 2022-03-24 | US | Missouri | Barton | 29011 | 2829 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-25 04:20:46 | Barton, Missouri, US | |
3024147 | 3024147 | 2022-03-23 | US | Missouri | Barton | 29011 | 2829 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-24 04:20:43 | Barton, Missouri, US | |
697432 | 697432 | 2022-03-17 | US | Texas | Camp | 48063 | 2829 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-18 04:20:55 | Camp, Texas, US | |
2322375 | 2322375 | 2022-03-16 | US | Texas | Camp | 48063 | 2829 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-17 04:20:56 | Camp, Texas, US | |
2141623 | 2141623 | 2022-03-09 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-10 04:20:48 | Metcalfe, Kentucky, US | |
921134 | 921134 | 2022-03-08 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-09 04:20:59 | Metcalfe, Kentucky, US | |
1549421 | 1549421 | 2022-03-07 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-08 04:20:54 | Metcalfe, Kentucky, US | |
2201090 | 2201090 | 2022-03-06 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-07 04:20:47 | Metcalfe, Kentucky, US | |
2093547 | 2093547 | 2022-03-05 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-06 04:20:49 | Metcalfe, Kentucky, US | |
2667247 | 2667247 | 2022-03-04 | US | Kentucky | Metcalfe | 21169 | 2829 | 59 | 0 | 36.99459295 | -85.63123699 | 2022-03-05 04:21:10 | Metcalfe, Kentucky, US | |
1058502 | 1058502 | 2022-02-23 | US | Colorado | Rio Grande | 8105 | 2829 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-02-24 04:21:14 | Rio Grande, Colorado, US | |
2447425 | 2447425 | 2022-02-22 | US | Colorado | Rio Grande | 8105 | 2829 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-02-23 04:21:09 | Rio Grande, Colorado, US | |
2447134 | 2447134 | 2022-02-22 | US | Alabama | Conecuh | 1035 | 2829 | 64 | 0 | 31.43401703 | -86.99320044 | 2022-02-23 04:21:09 | Conecuh, Alabama, US | |
2642524 | 2642524 | 2022-02-14 | US | Georgia | Charlton | 13049 | 2829 | 58 | 0 | 30.78371028 | -82.13951596 | 2022-02-15 04:21:09 | Charlton, Georgia, US | |
187767 | 187767 | 2022-02-13 | US | Minnesota | Aitkin | 27001 | 2829 | 59 | 0 | 46.60962049 | -93.41168259999999 | 2022-02-14 04:20:51 | Aitkin, Minnesota, US | |
317613 | 317613 | 2022-02-12 | US | Minnesota | Aitkin | 27001 | 2829 | 59 | 0 | 46.60962049 | -93.41168259999999 | 2022-02-13 04:21:00 | Aitkin, Minnesota, US | |
234939 | 234939 | 2022-02-11 | US | Minnesota | Aitkin | 27001 | 2829 | 59 | 0 | 46.60962049 | -93.41168259999999 | 2022-02-12 04:21:06 | Aitkin, Minnesota, US | |
2015085 | 2015085 | 2022-02-06 | US | North Carolina | Washington | 37187 | 2829 | 42 | 0 | 35.83810081 | -76.57299037 | 2022-02-07 04:21:05 | Washington, North Carolina, US | |
1296414 | 1296414 | 2022-02-05 | US | North Carolina | Washington | 37187 | 2829 | 42 | 0 | 35.83810081 | -76.57299037 | 2022-02-06 04:21:00 | Washington, North Carolina, US | |
2329742 | 2329742 | 2022-02-04 | US | North Carolina | Washington | 37187 | 2829 | 42 | 0 | 35.83810081 | -76.57299037 | 2022-02-05 04:21:05 | Washington, North Carolina, US | |
3813009 | 3813009 | 2022-01-28 | US | Texas | Duval | 48131 | 2829 | 63 | 0 | 27.68184592 | -98.50864568 | 2022-01-29 04:21:10 | Duval, Texas, US | |
2613628 | 2613628 | 2022-01-06 | US | Wisconsin | Rusk | 55107 | 2829 | 41 | 0 | 45.47498854 | -91.1333012 | 2022-01-07 04:22:09 | Rusk, Wisconsin, 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]);