johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where confirmed = 4983 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295171 | 295171 | 2022-11-15 | US | Texas | Lee | 48287 | 4983 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-16 04:21:09 | Lee, Texas, US | |
3600201 | 3600201 | 2022-11-14 | US | Texas | Lee | 48287 | 4983 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-15 04:21:16 | Lee, Texas, US | |
479353 | 479353 | 2022-11-08 | Canada | Yukon | 4983 | 32 | 0 | 64.2823 | -135.0 | 2022-11-09 04:21:22 | Yukon, Canada | |||
434131 | 434131 | 2022-11-03 | US | Puerto Rico | Patillas | 72109 | 4983 | 0 | 0 | 18.03174 | -66.012242 | 2022-11-04 04:22:11 | Patillas, Puerto Rico, US | |
852324 | 852324 | 2022-11-02 | US | Puerto Rico | Arroyo | 72015 | 4983 | 0 | 0 | 17.998457 | -66.056546 | 2022-11-03 04:22:05 | Arroyo, Puerto Rico, US | |
321356 | 321356 | 2022-10-30 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-31 04:21:36 | Jackson, Kentucky, US | |
913632 | 913632 | 2022-10-29 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-30 04:22:14 | Jackson, Kentucky, US | |
1367901 | 1367901 | 2022-10-28 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-29 04:21:13 | Jackson, Kentucky, US | |
3039756 | 3039756 | 2022-10-27 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-28 04:22:31 | Jackson, Kentucky, US | |
540176 | 540176 | 2022-10-26 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-27 04:22:01 | Jackson, Kentucky, US | |
1831577 | 1831577 | 2022-10-25 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-26 04:22:19 | Jackson, Kentucky, US | |
795838 | 795838 | 2022-10-24 | US | Kentucky | Jackson | 21109 | 4983 | 84 | 0 | 37.41866422 | -83.99825483 | 2022-10-25 04:21:53 | Jackson, Kentucky, US | |
3548495 | 3548495 | 2022-09-01 | US | Illinois | Ford | 17053 | 4983 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-02 04:21:07 | Ford, Illinois, US | |
2829360 | 2829360 | 2022-08-25 | US | California | Colusa | 6011 | 4983 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-08-26 04:21:02 | Colusa, California, US | |
3909515 | 3909515 | 2022-08-11 | US | Louisiana | Jackson | 22049 | 4983 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-12 04:20:54 | Jackson, Louisiana, US | |
3908488 | 3908488 | 2022-08-11 | US | Arkansas | Drew | 5043 | 4983 | 72 | 0 | 33.59035001 | -91.71777921 | 2022-08-12 04:20:54 | Drew, Arkansas, US | |
1101325 | 1101325 | 2022-08-03 | US | Texas | Reeves | 48389 | 4983 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-04 04:20:58 | Reeves, Texas, US | |
3874344 | 3874344 | 2022-07-31 | US | Puerto Rico | Santa Isabel | 72133 | 4983 | 0 | 0 | 17.994525 | -66.388913 | 2022-08-01 04:21:03 | Santa Isabel, Puerto Rico, US | |
670791 | 670791 | 2022-07-21 | US | Arkansas | Hempstead | 5057 | 4983 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-07-22 04:21:15 | Hempstead, Arkansas, US | |
1610810 | 1610810 | 2022-07-20 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-21 04:21:10 | Craig, Oklahoma, US | |
961443 | 961443 | 2022-07-19 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-20 04:20:59 | Craig, Oklahoma, US | |
3212830 | 3212830 | 2022-07-18 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-19 04:20:58 | Craig, Oklahoma, US | |
3408005 | 3408005 | 2022-07-17 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-18 04:20:59 | Craig, Oklahoma, US | |
2154205 | 2154205 | 2022-07-16 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-17 04:21:15 | Craig, Oklahoma, US | |
2421438 | 2421438 | 2022-07-15 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-16 04:21:05 | Craig, Oklahoma, US | |
3431513 | 3431513 | 2022-07-14 | US | Oklahoma | Craig | 40035 | 4983 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-07-15 04:20:53 | Craig, Oklahoma, US | |
630883 | 630883 | 2022-07-12 | US | Illinois | Clay | 17025 | 4983 | 69 | 0 | 38.75388572 | -88.48914513 | 2022-07-13 04:20:58 | Clay, Illinois, US | |
2492784 | 2492784 | 2022-06-29 | US | Puerto Rico | Naguabo | 72103 | 4983 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-30 04:21:01 | Naguabo, Puerto Rico, US | |
1766105 | 1766105 | 2022-06-20 | US | Puerto Rico | Salinas | 72123 | 4983 | 0 | 0 | 18.010387 | -66.256592 | 2022-06-21 04:20:56 | Salinas, Puerto Rico, US | |
3983582 | 3983582 | 2022-06-15 | US | Illinois | Clark | 17023 | 4983 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-06-16 04:20:55 | Clark, Illinois, US | |
950162 | 950162 | 2022-06-14 | US | Virginia | Buchanan | 51027 | 4983 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-15 04:20:54 | Buchanan, Virginia, US | |
3530643 | 3530643 | 2022-06-04 | US | Texas | Milam | 48331 | 4983 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-05 04:20:55 | Milam, Texas, US | |
1851978 | 1851978 | 2022-05-26 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-27 04:20:56 | Big Horn, Montana, US | |
2049854 | 2049854 | 2022-05-25 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-26 04:20:50 | Big Horn, Montana, US | |
3001292 | 3001292 | 2022-05-24 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-25 04:20:56 | Big Horn, Montana, US | |
3595013 | 3595013 | 2022-05-23 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-24 04:20:57 | Big Horn, Montana, US | |
623865 | 623865 | 2022-05-22 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-26 04:20:50 | Big Horn, Montana, US | |
1111561 | 1111561 | 2022-05-21 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-22 04:20:52 | Big Horn, Montana, US | |
1171185 | 1171185 | 2022-05-20 | US | Montana | Big Horn | 30003 | 4983 | 97 | 0 | 45.42335905 | -107.492347 | 2022-05-21 04:20:58 | Big Horn, Montana, US | |
1506819 | 1506819 | 2022-05-16 | US | Texas | Scurry | 48415 | 4983 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-05-17 04:20:59 | Scurry, Texas, US | |
2087178 | 2087178 | 2022-05-15 | US | Texas | Scurry | 48415 | 4983 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-05-16 04:20:47 | Scurry, Texas, US | |
3357888 | 3357888 | 2022-05-14 | US | Texas | Scurry | 48415 | 4983 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-05-15 04:20:53 | Scurry, Texas, US | |
3357409 | 3357409 | 2022-05-14 | US | Puerto Rico | Fajardo | 72053 | 4983 | 0 | 0 | 18.318373 | -65.666866 | 2022-05-15 04:20:53 | Fajardo, Puerto Rico, US | |
661533 | 661533 | 2022-05-13 | US | Texas | Scurry | 48415 | 4983 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-05-14 04:20:48 | Scurry, Texas, US | |
2533770 | 2533770 | 2022-05-12 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-13 04:20:51 | Fayette, Alabama, US | |
3445216 | 3445216 | 2022-05-11 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-12 04:20:54 | Fayette, Alabama, US | |
3535833 | 3535833 | 2022-05-10 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-11 04:20:48 | Fayette, Alabama, US | |
222368 | 222368 | 2022-05-09 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-10 04:20:50 | Fayette, Alabama, US | |
2332040 | 2332040 | 2022-05-08 | US | Colorado | Teller | 8119 | 4983 | 57 | 0 | 38.88133511 | -105.1614893 | 2022-05-09 04:20:54 | Teller, Colorado, US | |
2331753 | 2331753 | 2022-05-08 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-09 04:20:54 | Fayette, Alabama, US | |
360715 | 360715 | 2022-05-07 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-08 04:20:49 | Fayette, Alabama, US | |
1398066 | 1398066 | 2022-05-06 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-07 04:21:09 | Fayette, Alabama, US | |
2598421 | 2598421 | 2022-05-05 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-06 04:21:00 | Fayette, Alabama, US | |
3265870 | 3265870 | 2022-05-04 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-05 04:20:55 | Fayette, Alabama, US | |
1572509 | 1572509 | 2022-05-03 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-05-04 04:20:59 | Fayette, Alabama, US | |
1326867 | 1326867 | 2022-04-26 | US | Colorado | Elbert | 8039 | 4983 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-27 04:20:52 | Elbert, Colorado, US | |
2029142 | 2029142 | 2022-04-24 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-25 04:20:56 | Fayette, Alabama, US | |
746717 | 746717 | 2022-04-23 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-24 04:20:56 | Fayette, Alabama, US | |
3437202 | 3437202 | 2022-04-22 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-23 04:20:50 | Fayette, Alabama, US | |
2892787 | 2892787 | 2022-04-21 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-22 04:20:45 | Fayette, Alabama, US | |
2307659 | 2307659 | 2022-04-20 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-21 04:20:46 | Fayette, Alabama, US | |
2251798 | 2251798 | 2022-04-19 | US | Alabama | Fayette | 1057 | 4983 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-20 04:20:45 | Fayette, Alabama, US | |
3869856 | 3869856 | 2022-04-05 | US | North Carolina | Currituck | 37053 | 4983 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-06 04:20:49 | Currituck, North Carolina, US | |
27761 | 27761 | 2022-03-20 | US | Virginia | King George | 51099 | 4983 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-03-21 04:20:50 | King George, Virginia, US | |
1659771 | 1659771 | 2022-03-19 | US | Virginia | King George | 51099 | 4983 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-03-20 04:20:45 | King George, Virginia, US | |
339297 | 339297 | 2022-03-18 | US | Virginia | King George | 51099 | 4983 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-03-19 04:20:47 | King George, Virginia, US | |
338145 | 338145 | 2022-03-18 | US | New Mexico | Roosevelt | 35041 | 4983 | 92 | 0 | 34.02097406 | -103.4799493 | 2022-03-19 04:20:47 | Roosevelt, New Mexico, US | |
697750 | 697750 | 2022-03-17 | US | Virginia | King George | 51099 | 4983 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-03-18 04:20:55 | King George, Virginia, US | |
696598 | 696598 | 2022-03-17 | US | New Mexico | Roosevelt | 35041 | 4983 | 92 | 0 | 34.02097406 | -103.4799493 | 2022-03-18 04:20:55 | Roosevelt, New Mexico, US | |
1514048 | 1514048 | 2022-02-24 | US | Oregon | Union | 41061 | 4983 | 73 | 0 | 45.30915495 | -118.0068979 | 2022-02-25 04:21:11 | Union, Oregon, US | |
3822416 | 3822416 | 2022-02-16 | US | Missouri | Vernon | 29217 | 4983 | 99 | 0 | 37.8457799 | -94.34127305 | 2022-02-17 04:20:56 | Vernon, Missouri, US | |
319074 | 319074 | 2022-02-12 | US | Texas | Limestone | 48293 | 4983 | 117 | 0 | 31.5454767 | -96.58095444 | 2022-02-13 04:21:00 | Limestone, Texas, US | |
3074446 | 3074446 | 2022-02-09 | US | Alabama | Randolph | 1111 | 4983 | 71 | 0 | 33.29526734 | -85.45708831 | 2022-02-10 04:21:14 | Randolph, Alabama, US | |
2477285 | 2477285 | 2022-02-03 | US | Virginia | Dinwiddie | 51053 | 4983 | 64 | 0 | 37.07544585 | -77.63451754 | 2022-02-04 04:21:10 | Dinwiddie, Virginia, US | |
459379 | 459379 | 2022-02-02 | Japan | Iwate | 4983 | 53 | 0 | 39.593287 | 141.361777 | 2022-02-03 04:21:21 | Iwate, Japan | |||
978973 | 978973 | 2022-02-01 | Japan | Tokushima | 4983 | 68 | 0 | 33.919178 | 134.242091 | 2022-02-02 04:21:09 | Tokushima, Japan | |||
1319930 | 1319930 | 2022-01-26 | US | Minnesota | Dodge | 27039 | 4983 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-27 04:21:19 | Dodge, Minnesota, US | |
1114592 | 1114592 | 2022-01-11 | US | Illinois | Jersey | 17083 | 4983 | 58 | 0 | 39.08869046 | -90.35393073 | 2022-01-12 04:21:44 | Jersey, Illinois, US | |
1701224 | 1701224 | 2022-01-03 | US | Georgia | Stephens | 13257 | 4983 | 124 | 0 | 34.55151201 | -83.29405315 | 2022-01-04 04:22:17 | Stephens, Georgia, US | |
3521278 | 3521278 | 2022-01-02 | US | Mississippi | Scott | 28123 | 4983 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2022-01-03 02:22:25 | Scott, Mississippi, US | |
3520307 | 3520307 | 2022-01-02 | US | Georgia | Stephens | 13257 | 4983 | 124 | 0 | 34.55151201 | -83.29405315 | 2022-01-03 02:22:25 | Stephens, Georgia, US | |
3519845 | 3519845 | 2022-01-02 | US | Alabama | Winston | 1133 | 4983 | 111 | 0 | 34.15030532 | -87.37325922 | 2022-01-03 02:22:25 | Winston, Alabama, US | |
2169408 | 2169408 | 2022-01-01 | US | Mississippi | Scott | 28123 | 4983 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2022-01-02 04:20:52 | Scott, Mississippi, US | |
2168437 | 2168437 | 2022-01-01 | US | Georgia | Stephens | 13257 | 4983 | 124 | 0 | 34.55151201 | -83.29405315 | 2022-01-02 04:20:52 | Stephens, Georgia, US | |
2778839 | 2778839 | 2021-12-31 | US | Mississippi | Scott | 28123 | 4983 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2022-01-01 04:22:14 | Scott, Mississippi, US | |
2777868 | 2777868 | 2021-12-31 | US | Georgia | Stephens | 13257 | 4983 | 124 | 0 | 34.55151201 | -83.29405315 | 2022-01-01 04:22:14 | Stephens, Georgia, US | |
4000496 | 4000496 | 2021-12-30 | US | Mississippi | Scott | 28123 | 4983 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2021-12-31 04:21:50 | Scott, Mississippi, US | |
1671558 | 1671558 | 2021-12-29 | US | Texas | Gray | 48179 | 4983 | 93 | 0 | 35.40081878 | -100.8129222 | 2021-12-30 04:21:25 | Gray, Texas, US | |
801274 | 801274 | 2021-12-22 | US | South Carolina | Union | 45087 | 4983 | 113 | 0 | 34.68835752 | -81.61730349 | 2021-12-23 04:21:21 | Union, South Carolina, US | |
3830100 | 3830100 | 2021-12-21 | US | Michigan | Dickinson | 26043 | 4983 | 92 | 0 | 46.00999672 | -87.86961634 | 2021-12-22 04:21:54 | Dickinson, Michigan, US | |
1256403 | 1256403 | 2021-12-20 | US | Michigan | Dickinson | 26043 | 4983 | 92 | 0 | 46.00999672 | -87.86961634 | 2021-12-21 03:21:27 | Dickinson, Michigan, US | |
1255675 | 1255675 | 2021-12-20 | US | Georgia | White | 13311 | 4983 | 134 | 0 | 34.64624278 | -83.74905525 | 2021-12-21 03:21:27 | White, Georgia, US | |
406725 | 406725 | 2021-12-07 | US | North Dakota | Stutsman | 38093 | 4983 | 92 | 0 | 46.97962541 | -98.95637318 | 2021-12-08 04:22:46 | Stutsman, North Dakota, US | |
140753 | 140753 | 2021-12-04 | US | Puerto Rico | Toa Alta | 72135 | 4983 | 0 | 0 | 18.362406 | -66.246616 | 2021-12-05 04:22:25 | Toa Alta, Puerto Rico, US | |
1234757 | 1234757 | 2021-11-28 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-29 04:22:30 | Hutchinson, Texas, US | |
1361464 | 1361464 | 2021-11-27 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-28 04:22:43 | Hutchinson, Texas, US | |
761455 | 761455 | 2021-11-26 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-27 04:22:45 | Hutchinson, Texas, US | |
1805872 | 1805872 | 2021-11-25 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-26 04:22:33 | Hutchinson, Texas, US | |
907306 | 907306 | 2021-11-24 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-25 04:22:33 | Hutchinson, Texas, US | |
3073156 | 3073156 | 2021-11-23 | US | Texas | Hutchinson | 48233 | 4983 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-11-24 04:22:14 | Hutchinson, Texas, 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]);