johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
206 rows where confirmed = 3499 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175460 | 3175460 | 2022-12-19 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-20 04:21:04 | Missaukee, Michigan, US | |
1629977 | 1629977 | 2022-12-18 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-19 04:21:03 | Missaukee, Michigan, US | |
505356 | 505356 | 2022-12-17 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-18 04:21:03 | Missaukee, Michigan, US | |
3325928 | 3325928 | 2022-12-16 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-17 04:21:04 | Missaukee, Michigan, US | |
544440 | 544440 | 2022-12-15 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-16 04:21:01 | Missaukee, Michigan, US | |
349968 | 349968 | 2022-12-14 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-15 04:20:58 | Missaukee, Michigan, US | |
309556 | 309556 | 2022-12-13 | US | Michigan | Missaukee | 26113 | 3499 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-14 04:21:04 | Missaukee, Michigan, US | |
308541 | 308541 | 2022-12-13 | US | Colorado | Rio Grande | 8105 | 3499 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-14 04:21:04 | Rio Grande, Colorado, US | |
3936515 | 3936515 | 2022-12-09 | US | Arkansas | Bradley | 5011 | 3499 | 57 | 0 | 33.46755808 | -92.15980837 | 2022-12-10 04:21:02 | Bradley, Arkansas, US | |
3716560 | 3716560 | 2022-12-06 | US | North Dakota | Barnes | 38003 | 3499 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-12-07 04:20:58 | Barnes, North Dakota, US | |
3460777 | 3460777 | 2022-11-21 | US | Colorado | Crowley | 8025 | 3499 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-22 04:20:47 | Crowley, Colorado, US | |
1640962 | 1640962 | 2022-11-20 | US | Colorado | Crowley | 8025 | 3499 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-21 04:21:05 | Crowley, Colorado, US | |
2064519 | 2064519 | 2022-11-19 | US | Colorado | Crowley | 8025 | 3499 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-20 04:21:08 | Crowley, Colorado, US | |
1755913 | 1755913 | 2022-11-18 | US | Colorado | Crowley | 8025 | 3499 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-19 04:21:14 | Crowley, Colorado, US | |
3026906 | 3026906 | 2022-11-17 | US | Colorado | Crowley | 8025 | 3499 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-18 04:21:15 | Crowley, Colorado, US | |
2433461 | 2433461 | 2022-11-09 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-10 04:21:16 | Vinton, Ohio, US | |
482117 | 482117 | 2022-11-08 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-09 04:21:22 | Vinton, Ohio, US | |
2441267 | 2441267 | 2022-11-07 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-08 04:21:21 | Vinton, Ohio, US | |
1052365 | 1052365 | 2022-11-06 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-07 04:21:26 | Vinton, Ohio, US | |
620389 | 620389 | 2022-11-05 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-06 04:21:24 | Vinton, Ohio, US | |
1024893 | 1024893 | 2022-11-04 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-05 04:21:52 | Vinton, Ohio, US | |
433884 | 433884 | 2022-11-03 | US | Ohio | Vinton | 39163 | 3499 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-04 04:22:11 | Vinton, Ohio, US | |
3284692 | 3284692 | 2022-10-31 | China | Heilongjiang | 3499 | 13 | 0 | 47.862 | 127.7615 | 2022-11-01 04:22:36 | Heilongjiang, China | |||
2273814 | 2273814 | 2022-10-20 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-21 04:22:23 | Cedar, Missouri, US | |
200149 | 200149 | 2022-10-19 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-20 04:22:59 | Cedar, Missouri, US | |
2758810 | 2758810 | 2022-10-18 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-19 04:22:26 | Cedar, Missouri, US | |
2026644 | 2026644 | 2022-10-17 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-18 04:22:42 | Cedar, Missouri, US | |
2161422 | 2161422 | 2022-10-16 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-17 04:20:31 | Cedar, Missouri, US | |
517619 | 517619 | 2022-10-15 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-16 04:22:39 | Cedar, Missouri, US | |
2034676 | 2034676 | 2022-10-14 | US | Missouri | Cedar | 29039 | 3499 | 60 | 0 | 37.72391475 | -93.85445441 | 2022-10-15 04:22:00 | Cedar, Missouri, US | |
3250634 | 3250634 | 2022-10-11 | US | Arkansas | Desha | 5041 | 3499 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-12 04:22:51 | Desha, Arkansas, US | |
2967893 | 2967893 | 2022-10-10 | US | Arkansas | Desha | 5041 | 3499 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-11 04:23:05 | Desha, Arkansas, US | |
3097929 | 3097929 | 2022-10-09 | US | Arkansas | Desha | 5041 | 3499 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-10 04:22:32 | Desha, Arkansas, US | |
4003154 | 4003154 | 2022-10-08 | US | Arkansas | Desha | 5041 | 3499 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-09 04:21:16 | Desha, Arkansas, US | |
1626705 | 1626705 | 2022-09-22 | US | North Dakota | McKenzie | 38053 | 3499 | 25 | 0 | 47.7413337 | -103.395905 | 2022-09-23 04:23:13 | McKenzie, North Dakota, US | |
1372909 | 1372909 | 2022-09-21 | US | North Dakota | McKenzie | 38053 | 3499 | 25 | 0 | 47.7413337 | -103.395905 | 2022-09-22 04:22:56 | McKenzie, North Dakota, US | |
1101250 | 1101250 | 2022-08-03 | US | Texas | Jackson | 48239 | 3499 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-08-04 04:20:58 | Jackson, Texas, US | |
1068487 | 1068487 | 2022-07-28 | US | Oregon | Baker | 41001 | 3499 | 51 | 0 | 44.70915557 | -117.6749883 | 2022-07-29 04:20:45 | Baker, Oregon, US | |
971491 | 971491 | 2022-06-01 | US | California | Plumas | 6063 | 3499 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-06-02 05:20:39 | Plumas, California, US | |
3189404 | 3189404 | 2022-05-30 | US | Virginia | Southampton | 51175 | 3499 | 95 | 0 | 36.72231125 | -77.10642712 | 2022-05-31 04:20:51 | Southampton, Virginia, US | |
3189248 | 3189248 | 2022-05-30 | US | Texas | Wilbarger | 48487 | 3499 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-31 04:20:51 | Wilbarger, Texas, US | |
3201553 | 3201553 | 2022-05-29 | US | Virginia | Southampton | 51175 | 3499 | 95 | 0 | 36.72231125 | -77.10642712 | 2022-05-30 04:20:50 | Southampton, Virginia, US | |
3201397 | 3201397 | 2022-05-29 | US | Texas | Wilbarger | 48487 | 3499 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-30 04:20:50 | Wilbarger, Texas, US | |
2728431 | 2728431 | 2022-05-28 | US | Virginia | Southampton | 51175 | 3499 | 95 | 0 | 36.72231125 | -77.10642712 | 2022-05-29 04:20:53 | Southampton, Virginia, US | |
2728275 | 2728275 | 2022-05-28 | US | Texas | Wilbarger | 48487 | 3499 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-29 04:20:53 | Wilbarger, Texas, US | |
1317612 | 1317612 | 2022-05-27 | US | Virginia | Southampton | 51175 | 3499 | 95 | 0 | 36.72231125 | -77.10642712 | 2022-05-28 04:21:07 | Southampton, Virginia, US | |
1317456 | 1317456 | 2022-05-27 | US | Texas | Wilbarger | 48487 | 3499 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-28 04:21:07 | Wilbarger, Texas, US | |
1187242 | 1187242 | 2022-05-18 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-19 04:20:54 | Monroe, Ohio, US | |
3585139 | 3585139 | 2022-05-17 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-18 04:20:50 | Monroe, Ohio, US | |
1506096 | 1506096 | 2022-05-16 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-17 04:20:59 | Monroe, Ohio, US | |
2086455 | 2086455 | 2022-05-15 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-16 04:20:47 | Monroe, Ohio, US | |
3357165 | 3357165 | 2022-05-14 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-15 04:20:53 | Monroe, Ohio, US | |
660810 | 660810 | 2022-05-13 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-14 04:20:48 | Monroe, Ohio, US | |
2535893 | 2535893 | 2022-05-12 | US | Ohio | Monroe | 39111 | 3499 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-05-13 04:20:51 | Monroe, Ohio, US | |
2894698 | 2894698 | 2022-04-21 | US | New York | Yates | 36123 | 3499 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-04-22 04:20:45 | Yates, New York, US | |
2446206 | 2446206 | 2022-04-13 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-13 23:21:06 | Klickitat, Washington, US | |
1951963 | 1951963 | 2022-04-12 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-13 04:21:03 | Klickitat, Washington, US | |
1949539 | 1949539 | 2022-04-12 | US | Illinois | Menard | 17129 | 3499 | 20 | 0 | 40.02742725 | -89.80246001 | 2022-04-13 04:21:03 | Menard, Illinois, US | |
3209716 | 3209716 | 2022-04-11 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-12 04:20:49 | Klickitat, Washington, US | |
3207292 | 3207292 | 2022-04-11 | US | Illinois | Menard | 17129 | 3499 | 20 | 0 | 40.02742725 | -89.80246001 | 2022-04-12 04:20:49 | Menard, Illinois, US | |
1579602 | 1579602 | 2022-04-10 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-11 04:21:02 | Klickitat, Washington, US | |
1655844 | 1655844 | 2022-04-09 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-10 04:20:52 | Klickitat, Washington, US | |
2119166 | 2119166 | 2022-04-08 | US | Washington | Klickitat | 53039 | 3499 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-09 04:20:42 | Klickitat, Washington, US | |
2479738 | 2479738 | 2022-03-30 | US | Minnesota | Sibley | 27143 | 3499 | 24 | 0 | 44.5796592 | -94.23164924 | 2022-03-31 04:20:56 | Sibley, Minnesota, US | |
953638 | 953638 | 2022-03-12 | US | Puerto Rico | Quebradillas | 72115 | 3499 | 0 | 0 | 18.439692 | -66.926113 | 2022-03-13 04:20:49 | Quebradillas, Puerto Rico, US | |
359099 | 359099 | 2022-03-11 | US | Puerto Rico | Quebradillas | 72115 | 3499 | 0 | 0 | 18.439692 | -66.926113 | 2022-03-12 04:20:50 | Quebradillas, Puerto Rico, US | |
922306 | 922306 | 2022-03-08 | US | Oregon | Hood River | 41027 | 3499 | 42 | 0 | 45.51872811 | -121.65520359999998 | 2022-03-09 04:20:59 | Hood River, Oregon, US | |
1550593 | 1550593 | 2022-03-07 | US | Oregon | Hood River | 41027 | 3499 | 42 | 0 | 45.51872811 | -121.65520359999998 | 2022-03-08 04:20:54 | Hood River, Oregon, US | |
2200785 | 2200785 | 2022-03-06 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-07 04:20:47 | Tipton, Indiana, US | |
2093242 | 2093242 | 2022-03-05 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-06 04:20:49 | Tipton, Indiana, US | |
2666942 | 2666942 | 2022-03-04 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-05 04:21:10 | Tipton, Indiana, US | |
1645507 | 1645507 | 2022-03-03 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-04 04:21:09 | Tipton, Indiana, US | |
2526774 | 2526774 | 2022-03-02 | US | Kentucky | Green | 21087 | 3499 | 38 | 0 | 37.26484328 | -85.5540745 | 2022-03-03 04:21:01 | Green, Kentucky, US | |
2526510 | 2526510 | 2022-03-02 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-03 04:21:01 | Tipton, Indiana, US | |
1993804 | 1993804 | 2022-03-01 | US | Indiana | Tipton | 18159 | 3499 | 80 | 0 | 40.31123252 | -86.05234925 | 2022-03-02 04:21:07 | Tipton, Indiana, US | |
943978 | 943978 | 2022-02-28 | US | Indiana | Tipton | 18159 | 3499 | 79 | 0 | 40.31123252 | -86.05234925 | 2022-03-01 04:21:09 | Tipton, Indiana, US | |
2734169 | 2734169 | 2022-02-27 | US | Indiana | Tipton | 18159 | 3499 | 79 | 0 | 40.31123252 | -86.05234925 | 2022-02-28 04:21:05 | Tipton, Indiana, US | |
3047322 | 3047322 | 2022-02-26 | US | Indiana | Tipton | 18159 | 3499 | 79 | 0 | 40.31123252 | -86.05234925 | 2022-02-27 04:21:04 | Tipton, Indiana, US | |
575977 | 575977 | 2022-02-25 | US | Indiana | Tipton | 18159 | 3499 | 79 | 0 | 40.31123252 | -86.05234925 | 2022-02-26 04:21:12 | Tipton, Indiana, US | |
1301352 | 1301352 | 2022-02-17 | US | Virginia | Alleghany | 51005 | 3499 | 92 | 0 | 37.78636074 | -80.00222498 | 2022-02-18 04:21:04 | Alleghany, Virginia, US | |
187929 | 187929 | 2022-02-13 | US | Mississippi | Walthall | 28147 | 3499 | 77 | 0 | 31.14971548 | -90.10446654 | 2022-02-14 04:20:51 | Walthall, Mississippi, US | |
317775 | 317775 | 2022-02-12 | US | Mississippi | Walthall | 28147 | 3499 | 77 | 0 | 31.14971548 | -90.10446654 | 2022-02-13 04:21:00 | Walthall, Mississippi, US | |
235101 | 235101 | 2022-02-11 | US | Mississippi | Walthall | 28147 | 3499 | 77 | 0 | 31.14971548 | -90.10446654 | 2022-02-12 04:21:06 | Walthall, Mississippi, US | |
1782888 | 1782888 | 2022-01-27 | US | West Virginia | Monroe | 54063 | 3499 | 33 | 0 | 37.56274716 | -80.54577965 | 2022-01-28 04:21:09 | Monroe, West Virginia, US | |
3425306 | 3425306 | 2022-01-21 | US | Alabama | Clay | 1027 | 3499 | 71 | 0 | 33.26984193 | -85.85836077 | 2022-01-22 04:21:13 | Clay, Alabama, US | |
1962009 | 1962009 | 2022-01-20 | US | Kentucky | Morgan | 21175 | 3499 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-21 04:21:09 | Morgan, Kentucky, US | |
101219 | 101219 | 2022-01-14 | US | Missouri | Cooper | 29053 | 3499 | 64 | 0 | 38.844478 | -92.80896081 | 2022-01-15 04:21:07 | Cooper, Missouri, US | |
1287506 | 1287506 | 2022-01-04 | US | Louisiana | Concordia | 22029 | 3499 | 80 | 0 | 31.44817835 | -91.63814433 | 2022-01-05 04:21:59 | Concordia, Louisiana, US | |
4001403 | 4001403 | 2021-12-30 | US | Puerto Rico | Juncos | 72077 | 3499 | 0 | 0 | 18.223793 | -65.909109 | 2021-12-31 04:21:50 | Juncos, Puerto Rico, US | |
3999044 | 3999044 | 2021-12-30 | US | Alabama | Monroe | 1099 | 3499 | 66 | 0 | 31.56729412 | -87.36995001 | 2021-12-31 04:21:50 | Monroe, Alabama, US | |
3819630 | 3819630 | 2021-12-23 | US | Texas | Robertson | 48395 | 3499 | 68 | 0 | 31.02539637 | -96.51272246 | 2021-12-24 04:21:34 | Robertson, Texas, US | |
1667916 | 1667916 | 2021-12-11 | US | West Virginia | Brooke | 54009 | 3499 | 81 | 0 | 40.27367263 | -80.57915332 | 2021-12-12 04:22:12 | Brooke, West Virginia, US | |
551287 | 551287 | 2021-12-08 | US | Arkansas | Ouachita | 5103 | 3499 | 87 | 0 | 33.58839816 | -92.87795984 | 2021-12-09 04:22:49 | Ouachita, Arkansas, US | |
1742010 | 1742010 | 2021-12-05 | US | Kentucky | Simpson | 21213 | 3499 | 65 | 0 | 36.74058474 | -86.58047435 | 2021-12-06 04:22:34 | Simpson, Kentucky, US | |
3403016 | 3403016 | 2021-11-30 | US | Maryland | Caroline | 24011 | 3499 | 54 | 0 | 38.87172293 | -75.82904158 | 2021-12-01 04:22:29 | Caroline, Maryland, US | |
150965 | 150965 | 2021-11-29 | US | Illinois | Douglas | 17041 | 3499 | 38 | 0 | 39.76768052 | -88.21854195 | 2021-11-30 04:22:53 | Douglas, Illinois, US | |
907738 | 907738 | 2021-11-24 | US | Wisconsin | Langlade | 55067 | 3499 | 59 | 0 | 45.26271619 | -89.07483625 | 2021-11-25 04:22:33 | Langlade, Wisconsin, US | |
3751137 | 3751137 | 2021-11-22 | US | Montana | Lincoln | 30053 | 3499 | 64 | 0 | 48.54265777 | -115.4046155 | 2021-11-23 04:22:39 | Lincoln, Montana, US | |
3749883 | 3749883 | 2021-11-22 | US | Georgia | Berrien | 13019 | 3499 | 70 | 0 | 31.27590016 | -83.22529920000002 | 2021-11-23 04:22:39 | Berrien, Georgia, US | |
1015090 | 1015090 | 2021-11-21 | US | Georgia | Berrien | 13019 | 3499 | 70 | 0 | 31.27590016 | -83.22529920000002 | 2021-11-22 04:22:20 | Berrien, Georgia, 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]);