johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where confirmed = 5506 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755665 | 2755665 | 2022-12-29 | US | Puerto Rico | Loiza | 72087 | 5506 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-30 04:21:04 | Loiza, Puerto Rico, US | |
1076671 | 1076671 | 2022-12-28 | US | Puerto Rico | Loiza | 72087 | 5506 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-29 04:21:01 | Loiza, Puerto Rico, US | |
330668 | 330668 | 2022-12-27 | US | Puerto Rico | Loiza | 72087 | 5506 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-28 04:21:04 | Loiza, Puerto Rico, US | |
219959 | 219959 | 2022-12-26 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-27 04:21:07 | Texas, Missouri, US | |
3224416 | 3224416 | 2022-12-25 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-26 04:21:06 | Texas, Missouri, US | |
1020330 | 1020330 | 2022-12-24 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-25 04:21:04 | Texas, Missouri, US | |
692353 | 692353 | 2022-12-23 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-24 04:21:02 | Texas, Missouri, US | |
2181563 | 2181563 | 2022-12-22 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-23 04:21:04 | Texas, Missouri, US | |
453367 | 453367 | 2022-12-21 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-22 04:20:56 | Texas, Missouri, US | |
2953366 | 2953366 | 2022-12-20 | US | Missouri | Texas | 29215 | 5506 | 112 | 0 | 37.31728859 | -91.96564727 | 2022-12-21 04:21:03 | Texas, Missouri, US | |
506673 | 506673 | 2022-12-17 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-18 04:21:03 | Polk, Tennessee, US | |
3327245 | 3327245 | 2022-12-16 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-17 04:21:04 | Polk, Tennessee, US | |
545757 | 545757 | 2022-12-15 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-16 04:21:01 | Polk, Tennessee, US | |
351285 | 351285 | 2022-12-14 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-15 04:20:58 | Polk, Tennessee, US | |
1150960 | 1150960 | 2022-12-12 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-11 23:21:04 | Lincoln, Montana, US | |
870814 | 870814 | 2022-12-11 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-11 23:21:04 | Lincoln, Montana, US | |
259344 | 259344 | 2022-12-10 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-11 04:20:50 | Lincoln, Montana, US | |
3938058 | 3938058 | 2022-12-09 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-10 04:21:02 | Lincoln, Montana, US | |
3379390 | 3379390 | 2022-12-08 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-09 04:21:05 | Lincoln, Montana, US | |
1986661 | 1986661 | 2022-12-07 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-08 04:21:07 | Lincoln, Montana, US | |
1986219 | 1986219 | 2022-12-07 | US | Maine | Washington | 23029 | 5506 | 66 | 0 | 45.01607142 | -67.62813524 | 2022-12-08 04:21:07 | Washington, Maine, US | |
3716184 | 3716184 | 2022-12-06 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-07 04:20:58 | Lincoln, Montana, US | |
2416889 | 2416889 | 2022-12-05 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-06 04:21:03 | Lincoln, Montana, US | |
720497 | 720497 | 2022-12-04 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-05 04:20:58 | Lincoln, Montana, US | |
2818786 | 2818786 | 2022-12-03 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-04 04:20:56 | Lincoln, Montana, US | |
835642 | 835642 | 2022-12-02 | US | Montana | Lincoln | 30053 | 5506 | 95 | 0 | 48.54265777 | -115.4046155 | 2022-12-03 04:21:02 | Lincoln, Montana, US | |
320536 | 320536 | 2022-10-30 | US | Colorado | Alamosa | 8003 | 5506 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-31 04:21:36 | Alamosa, Colorado, US | |
912812 | 912812 | 2022-10-29 | US | Colorado | Alamosa | 8003 | 5506 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-30 04:22:14 | Alamosa, Colorado, US | |
1367081 | 1367081 | 2022-10-28 | US | Colorado | Alamosa | 8003 | 5506 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-29 04:21:13 | Alamosa, Colorado, US | |
3038936 | 3038936 | 2022-10-27 | US | Colorado | Alamosa | 8003 | 5506 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-28 04:22:31 | Alamosa, Colorado, US | |
3214854 | 3214854 | 2022-10-12 | US | California | Inyo | 6027 | 5506 | 59 | 0 | 36.51112084 | -117.4111978 | 2022-10-13 04:22:39 | Inyo, California, US | |
3253667 | 3253667 | 2022-10-11 | US | West Virginia | Taylor | 54091 | 5506 | 79 | 0 | 39.33602617 | -80.0421439 | 2022-10-12 04:22:51 | Taylor, West Virginia, US | |
2998007 | 2998007 | 2022-10-01 | US | Puerto Rico | Adjuntas | 72001 | 5506 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-02 04:21:23 | Adjuntas, Puerto Rico, US | |
3987248 | 3987248 | 2022-09-15 | US | Colorado | Elbert | 8039 | 5506 | 44 | 0 | 39.28656773 | -104.1358721 | 2022-09-16 04:21:19 | Elbert, Colorado, US | |
3769099 | 3769099 | 2022-09-11 | US | Texas | Scurry | 48415 | 5506 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-12 04:20:58 | Scurry, Texas, US | |
3827674 | 3827674 | 2022-09-10 | US | Texas | Scurry | 48415 | 5506 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-11 04:20:50 | Scurry, Texas, US | |
966131 | 966131 | 2022-09-09 | US | Texas | Scurry | 48415 | 5506 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-10 04:21:10 | Scurry, Texas, US | |
1880164 | 1880164 | 2022-08-28 | US | Texas | Milam | 48331 | 5506 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-08-29 04:21:06 | Milam, Texas, US | |
2099291 | 2099291 | 2022-08-27 | US | Texas | Milam | 48331 | 5506 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-08-28 04:21:02 | Milam, Texas, US | |
1535106 | 1535106 | 2022-08-26 | US | Texas | Milam | 48331 | 5506 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-08-27 04:20:57 | Milam, Texas, US | |
2829940 | 2829940 | 2022-08-25 | US | Indiana | Orange | 18117 | 5506 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-08-26 04:21:02 | Orange, Indiana, US | |
2324473 | 2324473 | 2022-08-24 | US | Indiana | Orange | 18117 | 5506 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-08-25 04:21:13 | Orange, Indiana, US | |
3908664 | 3908664 | 2022-08-11 | US | Colorado | Teller | 8119 | 5506 | 59 | 0 | 38.88133511 | -105.1614893 | 2022-08-12 04:20:54 | Teller, Colorado, US | |
962291 | 962291 | 2022-07-19 | US | Virginia | Prince Edward | 51147 | 5506 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-20 04:20:59 | Prince Edward, Virginia, US | |
961898 | 961898 | 2022-07-19 | US | Tennessee | Unicoi | 47171 | 5506 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-07-20 04:20:59 | Unicoi, Tennessee, US | |
960485 | 960485 | 2022-07-19 | US | Maryland | Somerset | 24039 | 5506 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-07-20 04:20:59 | Somerset, Maryland, US | |
2154589 | 2154589 | 2022-07-16 | US | Tennessee | Crockett | 47033 | 5506 | 88 | 0 | 35.81830662 | -89.14916269 | 2022-07-17 04:21:15 | Crockett, Tennessee, US | |
2242187 | 2242187 | 2022-06-28 | US | Puerto Rico | Utuado | 72141 | 5506 | 0 | 0 | 18.271214 | -66.702984 | 2022-06-29 04:20:59 | Utuado, Puerto Rico, US | |
478804 | 478804 | 2022-06-26 | US | Virginia | King George | 51099 | 5506 | 40 | 0 | 38.26818502 | -77.15852768 | 2022-06-27 04:21:00 | King George, Virginia, US | |
942179 | 942179 | 2022-06-25 | US | Virginia | King George | 51099 | 5506 | 40 | 0 | 38.26818502 | -77.15852768 | 2022-06-26 04:21:02 | King George, Virginia, US | |
3349999 | 3349999 | 2022-06-24 | US | Virginia | King George | 51099 | 5506 | 40 | 0 | 38.26818502 | -77.15852768 | 2022-06-25 04:20:57 | King George, Virginia, US | |
1423877 | 1423877 | 2022-06-08 | US | Puerto Rico | Quebradillas | 72115 | 5506 | 0 | 0 | 18.439692 | -66.926113 | 2022-06-09 04:20:54 | Quebradillas, Puerto Rico, US | |
3508443 | 3508443 | 2022-06-05 | US | Illinois | Union | 17181 | 5506 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-06-06 04:20:57 | Union, Illinois, US | |
3528520 | 3528520 | 2022-06-04 | US | Illinois | Union | 17181 | 5506 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-06-05 04:20:55 | Union, Illinois, US | |
3134606 | 3134606 | 2022-06-03 | US | Illinois | Union | 17181 | 5506 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-06-04 04:20:58 | Union, Illinois, US | |
1851004 | 1851004 | 2022-05-26 | US | Illinois | Lawrence | 17101 | 5506 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-27 04:20:56 | Lawrence, Illinois, US | |
2048880 | 2048880 | 2022-05-25 | US | Illinois | Lawrence | 17101 | 5506 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-26 04:20:50 | Lawrence, Illinois, US | |
622891 | 622891 | 2022-05-22 | US | Illinois | Lawrence | 17101 | 5506 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-26 04:20:50 | Lawrence, Illinois, US | |
2599916 | 2599916 | 2022-05-05 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-06 04:21:00 | Adair, Missouri, US | |
3267365 | 3267365 | 2022-05-04 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-05 04:20:55 | Adair, Missouri, US | |
1574004 | 1574004 | 2022-05-03 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-04 04:20:59 | Adair, Missouri, US | |
465264 | 465264 | 2022-05-02 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-03 04:21:00 | Adair, Missouri, US | |
3917903 | 3917903 | 2022-05-01 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-02 04:21:10 | Adair, Missouri, US | |
2842707 | 2842707 | 2022-04-30 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-01 04:20:57 | Adair, Missouri, US | |
1159020 | 1159020 | 2022-04-29 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-30 04:21:05 | Adair, Missouri, US | |
1698202 | 1698202 | 2022-04-28 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-29 04:20:59 | Adair, Missouri, US | |
1951273 | 1951273 | 2022-04-12 | US | Puerto Rico | Manati | 72091 | 5506 | 0 | 0 | 18.420473 | -66.490461 | 2022-04-13 04:21:03 | Manati, Puerto Rico, US | |
3209026 | 3209026 | 2022-04-11 | US | Puerto Rico | Manati | 72091 | 5506 | 0 | 0 | 18.420473 | -66.490461 | 2022-04-12 04:20:49 | Manati, Puerto Rico, US | |
2266127 | 2266127 | 2022-03-14 | US | New York | Essex | 36031 | 5506 | 57 | 0 | 44.11630765 | -73.77297842 | 2022-03-15 04:20:47 | Essex, New York, US | |
2526731 | 2526731 | 2022-03-02 | US | Kentucky | Adair | 21001 | 5506 | 99 | 0 | 37.10459774 | -85.28129668 | 2022-03-03 04:21:01 | Adair, Kentucky, US | |
1994250 | 1994250 | 2022-03-01 | US | Maryland | Talbot | 24041 | 5506 | 82 | 0 | 38.76618159 | -76.10882561 | 2022-03-02 04:21:07 | Talbot, Maryland, US | |
3673863 | 3673863 | 2022-02-15 | US | New Mexico | San Miguel | 35047 | 5506 | 49 | 0 | 35.48014807 | -104.8163562 | 2022-02-16 04:21:10 | San Miguel, New Mexico, US | |
1467159 | 1467159 | 2022-02-10 | US | Texas | Dimmit | 48127 | 5506 | 50 | 0 | 28.42270064 | -99.75645095 | 2022-02-11 04:21:09 | Dimmit, Texas, US | |
3075492 | 3075492 | 2022-02-09 | US | Kentucky | Meade | 21163 | 5506 | 61 | 0 | 37.96163597 | -86.21028219 | 2022-02-10 04:21:14 | Meade, Kentucky, US | |
2327891 | 2327891 | 2022-02-04 | US | Arkansas | Sevier | 5133 | 5506 | 64 | 0 | 33.99780401 | -94.2424869 | 2022-02-05 04:21:05 | Sevier, Arkansas, US | |
2659645 | 2659645 | 2022-01-31 | US | Mississippi | Tishomingo | 28141 | 5506 | 103 | 0 | 34.74023475 | -88.23917219 | 2022-02-01 04:21:11 | Tishomingo, Mississippi, US | |
1692971 | 1692971 | 2022-01-10 | US | Colorado | Routt | 8107 | 5506 | 24 | 0 | 40.48596505 | -106.9905548 | 2022-01-11 04:22:01 | Routt, Colorado, US | |
1283397 | 1283397 | 2022-01-05 | US | Kentucky | Grayson | 21085 | 5506 | 109 | 0 | 37.46231118 | -86.34248968 | 2022-01-06 04:22:09 | Grayson, Kentucky, US | |
3520568 | 3520568 | 2022-01-02 | US | Indiana | Scott | 18143 | 5506 | 82 | 0 | 38.68672078 | -85.74627859 | 2022-01-03 02:22:25 | Scott, Indiana, US | |
2168698 | 2168698 | 2022-01-01 | US | Indiana | Scott | 18143 | 5506 | 82 | 0 | 38.68672078 | -85.74627859 | 2022-01-02 04:20:52 | Scott, Indiana, US | |
2778129 | 2778129 | 2021-12-31 | US | Indiana | Scott | 18143 | 5506 | 82 | 0 | 38.68672078 | -85.74627859 | 2022-01-01 04:22:14 | Scott, Indiana, US | |
3999786 | 3999786 | 2021-12-30 | US | Indiana | Scott | 18143 | 5506 | 82 | 0 | 38.68672078 | -85.74627859 | 2021-12-31 04:21:50 | Scott, Indiana, US | |
1234333 | 1234333 | 2021-11-28 | US | Pennsylvania | Tioga | 42117 | 5506 | 148 | 0 | 41.77255149 | -77.25433032 | 2021-11-29 04:22:30 | Tioga, Pennsylvania, US | |
163417 | 163417 | 2021-11-19 | US | Kentucky | Clark | 21049 | 5506 | 43 | 0 | 37.9689263 | -84.14615986 | 2021-11-20 04:22:17 | Clark, Kentucky, US | |
1323606 | 1323606 | 2021-11-14 | US | Kentucky | Boyle | 21021 | 5506 | 83 | 0 | 37.62680923 | -84.8633779 | 2021-11-15 04:21:36 | Boyle, Kentucky, US | |
89417 | 89417 | 2021-11-09 | US | North Carolina | Bladen | 37017 | 5506 | 95 | 0 | 34.61296243 | -78.56180059 | 2021-11-10 04:21:38 | Bladen, North Carolina, US | |
599311 | 599311 | 2021-10-19 | US | Michigan | Gratiot | 26057 | 5506 | 125 | 0 | 43.29265605 | -84.60505416 | 2021-10-20 04:21:00 | Gratiot, Michigan, US | |
2045488 | 2045488 | 2021-10-18 | US | Michigan | Gratiot | 26057 | 5506 | 125 | 0 | 43.29265605 | -84.60505416 | 2021-10-19 04:20:54 | Gratiot, Michigan, US | |
426358 | 426358 | 2021-10-10 | US | Tennessee | White | 47185 | 5506 | 92 | 0 | 35.92929884 | -85.45591799 | 2021-10-11 04:21:31 | White, Tennessee, US | |
2960530 | 2960530 | 2021-10-08 | US | Indiana | Whitley | 18183 | 5506 | 54 | 0 | 41.13863784 | -85.50791236 | 2021-10-09 04:21:34 | Whitley, Indiana, US | |
2773508 | 2773508 | 2021-09-30 | US | Arkansas | Unassigned | 90005 | 5506 | 0 | 0 | 36.38177105 | 0.0 | 2021-10-01 04:21:35 | Unassigned, Arkansas, US | |
2077926 | 2077926 | 2021-09-26 | US | Missouri | Webster | 29225 | 5506 | 86 | 0 | 37.2813734 | -92.876329 | 2021-09-27 04:21:16 | Webster, Missouri, US | |
605097 | 605097 | 2021-09-23 | US | Virginia | Shenandoah | 51171 | 5506 | 141 | 0 | 38.85905135 | -78.56813762 | 2021-09-24 04:21:44 | Shenandoah, Virginia, US | |
2466066 | 2466066 | 2021-09-14 | US | Utah | Wasatch | 49051 | 5506 | 26 | 0 | 40.33110236 | -111.1691419 | 2021-09-15 03:22:37 | Wasatch, Utah, US | |
68935 | 68935 | 2021-09-01 | US | Missouri | Butler | 29023 | 5506 | 60 | 0 | 36.71462476 | -90.40421163 | 2021-09-02 04:21:15 | Butler, Missouri, US | |
1778921 | 1778921 | 2021-08-30 | US | Wisconsin | Oconto | 55083 | 5506 | 74 | 0 | 45.02715345 | -88.26807503 | 2021-08-31 04:21:46 | Oconto, Wisconsin, US | |
3168550 | 3168550 | 2021-08-23 | US | Tennessee | Cocke | 47029 | 5506 | 102 | 0 | 35.9278914 | -83.11828725 | 2021-08-24 04:21:19 | Cocke, Tennessee, US | |
104740 | 104740 | 2021-08-15 | US | Kentucky | Hopkins | 21107 | 5506 | 155 | 0 | 37.30939025 | -87.54670406 | 2021-08-16 04:21:31 | Hopkins, Kentucky, US | |
1120705 | 1120705 | 2021-08-06 | US | Texas | Hill | 48217 | 5506 | 111 | 0 | 31.99045053 | -97.13423143 | 2021-08-07 04:21:30 | Hill, Texas, US | |
335411 | 335411 | 2021-08-04 | US | West Virginia | Putnam | 54079 | 5506 | 93 | 0 | 38.50782345 | -81.9082131 | 2021-08-05 04:21:51 | Putnam, West Virginia, 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]);