johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
183 rows where confirmed = 3902 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
482652 | 482652 | 2022-11-08 | US | Texas | Comanche | 48093 | 3902 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-11-09 04:21:22 | Comanche, Texas, US | |
2441802 | 2441802 | 2022-11-07 | US | Texas | Comanche | 48093 | 3902 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-11-08 04:21:21 | Comanche, Texas, US | |
711078 | 711078 | 2022-11-01 | US | Colorado | Grand | 8049 | 3902 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-11-02 04:22:09 | Grand, Colorado, US | |
3747695 | 3747695 | 2022-09-07 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-08 04:21:02 | Okfuskee, Oklahoma, US | |
117717 | 117717 | 2022-09-06 | US | Tennessee | Lewis | 47101 | 3902 | 64 | 0 | 35.52853208 | -87.49022694 | 2022-09-07 04:20:59 | Lewis, Tennessee, US | |
117335 | 117335 | 2022-09-06 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-07 04:20:59 | Okfuskee, Oklahoma, US | |
2636307 | 2636307 | 2022-09-05 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-06 04:21:02 | Okfuskee, Oklahoma, US | |
2989871 | 2989871 | 2022-09-04 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-05 04:21:01 | Okfuskee, Oklahoma, US | |
2715556 | 2715556 | 2022-09-03 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-04 04:21:22 | Okfuskee, Oklahoma, US | |
1396261 | 1396261 | 2022-09-02 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-03 04:21:04 | Okfuskee, Oklahoma, US | |
3550090 | 3550090 | 2022-09-01 | US | Oklahoma | Okfuskee | 40107 | 3902 | 63 | 0 | 35.46485198 | -96.32639984 | 2022-09-02 04:21:07 | Okfuskee, Oklahoma, US | |
3774441 | 3774441 | 2022-08-30 | US | Arkansas | Van Buren | 5141 | 3902 | 63 | 0 | 35.58095779 | -92.51295036 | 2022-08-31 04:20:57 | Van Buren, Arkansas, US | |
1534670 | 1534670 | 2022-08-26 | US | Puerto Rico | Florida | 72054 | 3902 | 0 | 0 | 18.373715 | -66.560488 | 2022-08-27 04:20:57 | Florida, Puerto Rico, US | |
2832348 | 2832348 | 2022-08-25 | US | Wisconsin | Buffalo | 55011 | 3902 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-08-26 04:21:02 | Buffalo, Wisconsin, US | |
1068162 | 1068162 | 2022-07-28 | US | New York | Yates | 36123 | 3902 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-29 04:20:45 | Yates, New York, US | |
2422156 | 2422156 | 2022-07-15 | US | Texas | Zapata | 48505 | 3902 | 55 | 0 | 27.00156391 | -99.16987152 | 2022-07-16 04:21:05 | Zapata, Texas, US | |
2789417 | 2789417 | 2022-07-10 | US | Alabama | Lamar | 1075 | 3902 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-11 04:20:46 | Lamar, Alabama, US | |
142370 | 142370 | 2022-07-09 | US | Alabama | Lamar | 1075 | 3902 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-10 04:20:54 | Lamar, Alabama, US | |
1417470 | 1417470 | 2022-07-08 | US | Alabama | Lamar | 1075 | 3902 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-09 04:20:59 | Lamar, Alabama, US | |
3969940 | 3969940 | 2022-07-05 | US | Virginia | Patrick | 51141 | 3902 | 97 | 0 | 36.6801638 | -80.2865648 | 2022-07-06 04:20:58 | Patrick, Virginia, US | |
3081451 | 3081451 | 2022-07-04 | US | Virginia | Patrick | 51141 | 3902 | 97 | 0 | 36.6801638 | -80.2865648 | 2022-07-05 04:20:45 | Patrick, Virginia, US | |
3079712 | 3079712 | 2022-07-04 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-07-05 04:20:45 | Kalkaska, Michigan, US | |
1770903 | 1770903 | 2022-07-03 | US | Wisconsin | Lafayette | 55065 | 3902 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-07-04 04:20:54 | Lafayette, Wisconsin, US | |
1768994 | 1768994 | 2022-07-03 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-07-04 04:20:54 | Kalkaska, Michigan, US | |
3368889 | 3368889 | 2022-07-02 | US | Wisconsin | Lafayette | 55065 | 3902 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-07-03 04:20:59 | Lafayette, Wisconsin, US | |
3366980 | 3366980 | 2022-07-02 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-07-03 04:20:59 | Kalkaska, Michigan, US | |
597218 | 597218 | 2022-07-01 | US | Wisconsin | Lafayette | 55065 | 3902 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-07-02 04:21:16 | Lafayette, Wisconsin, US | |
595309 | 595309 | 2022-07-01 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-07-02 04:21:16 | Kalkaska, Michigan, US | |
3943619 | 3943619 | 2022-06-30 | US | Wisconsin | Lafayette | 55065 | 3902 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-07-01 04:21:10 | Lafayette, Wisconsin, US | |
3941710 | 3941710 | 2022-06-30 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-07-01 04:21:10 | Kalkaska, Michigan, US | |
2491668 | 2491668 | 2022-06-29 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-06-30 04:21:01 | Kalkaska, Michigan, US | |
2241050 | 2241050 | 2022-06-28 | US | Michigan | Kalkaska | 26079 | 3902 | 62 | 0 | 44.68512729 | -85.09085699 | 2022-06-29 04:20:59 | Kalkaska, Michigan, US | |
2150655 | 2150655 | 2022-06-27 | US | Texas | Andrews | 48003 | 3902 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-28 04:20:58 | Andrews, Texas, US | |
478456 | 478456 | 2022-06-26 | US | Texas | Andrews | 48003 | 3902 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-27 04:21:00 | Andrews, Texas, US | |
1651150 | 1651150 | 2022-06-23 | US | Puerto Rico | Penuelas | 72111 | 3902 | 0 | 0 | 18.059645 | -66.721572 | 2022-06-24 04:20:58 | Penuelas, Puerto Rico, US | |
1398188 | 1398188 | 2022-05-06 | US | Arkansas | Izard | 5065 | 3902 | 70 | 0 | 36.09604046 | -91.90847954 | 2022-05-07 04:21:09 | Izard, Arkansas, US | |
2598543 | 2598543 | 2022-05-05 | US | Arkansas | Izard | 5065 | 3902 | 70 | 0 | 36.09604046 | -91.90847954 | 2022-05-06 04:21:00 | Izard, Arkansas, US | |
2254899 | 2254899 | 2022-04-19 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-20 04:20:45 | Braxton, West Virginia, US | |
1224619 | 1224619 | 2022-04-14 | US | Illinois | Mason | 17125 | 3902 | 60 | 0 | 40.23917274 | -89.91824452 | 2022-04-15 04:20:57 | Mason, Illinois, US | |
3323714 | 3323714 | 2022-04-07 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-08 04:20:48 | Braxton, West Virginia, US | |
2804250 | 2804250 | 2022-04-06 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-07 04:20:53 | Braxton, West Virginia, US | |
2800539 | 2800539 | 2022-04-06 | Canada | Yukon | 3902 | 24 | 0 | 64.2823 | -135.0 | 2022-04-07 04:20:53 | Yukon, Canada | |||
3733707 | 3733707 | 2022-04-03 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-04 04:20:51 | Braxton, West Virginia, US | |
503142 | 503142 | 2022-04-02 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-03 04:20:48 | Braxton, West Virginia, US | |
3354127 | 3354127 | 2022-04-01 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-02 04:20:47 | Braxton, West Virginia, US | |
1543432 | 1543432 | 2022-03-31 | US | West Virginia | Braxton | 54007 | 3902 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-04-01 04:20:28 | Braxton, West Virginia, US | |
2481235 | 2481235 | 2022-03-30 | US | Texas | Young | 48503 | 3902 | 90 | 0 | 33.17659707 | -98.68790885 | 2022-03-31 04:20:56 | Young, Texas, US | |
3239140 | 3239140 | 2022-03-21 | US | Georgia | Greene | 13133 | 3902 | 83 | 0 | 33.5769205 | -83.17139104 | 2022-03-22 04:20:54 | Greene, Georgia, US | |
943660 | 943660 | 2022-02-28 | US | Georgia | Jeff Davis | 13161 | 3902 | 66 | 0 | 31.80405727 | -82.63724870000001 | 2022-03-01 04:21:09 | Jeff Davis, Georgia, US | |
3721718 | 3721718 | 2022-02-21 | US | Wisconsin | Burnett | 55013 | 3902 | 41 | 0 | 45.86303537 | -92.36711412 | 2022-02-22 04:21:01 | Burnett, Wisconsin, US | |
318931 | 318931 | 2022-02-12 | US | Texas | Aransas | 48007 | 3902 | 73 | 0 | 28.10556197 | -96.9995047 | 2022-02-13 04:21:00 | Aransas, Texas, US | |
982471 | 982471 | 2022-02-01 | US | West Virginia | Wetzel | 54103 | 3902 | 71 | 0 | 39.6065771 | -80.64016540000001 | 2022-02-02 04:21:09 | Wetzel, West Virginia, US | |
980097 | 980097 | 2022-02-01 | US | Indiana | Vermillion | 18165 | 3902 | 67 | 0 | 39.8523352 | -87.46160542 | 2022-02-02 04:21:09 | Vermillion, Indiana, US | |
2658148 | 2658148 | 2022-01-31 | US | Alabama | Clay | 1027 | 3902 | 72 | 0 | 33.26984193 | -85.85836077 | 2022-02-01 04:21:11 | Clay, Alabama, US | |
1321717 | 1321717 | 2022-01-26 | US | West Virginia | Morgan | 54065 | 3902 | 57 | 0 | 39.55439028 | -78.26311676 | 2022-01-27 04:21:19 | Morgan, West Virginia, US | |
2054625 | 2054625 | 2022-01-25 | US | Puerto Rico | Guayama | 72057 | 3902 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-01-26 04:21:07 | Guayama, Puerto Rico, US | |
1475642 | 1475642 | 2022-01-17 | US | Wisconsin | Adams | 55001 | 3902 | 45 | 0 | 43.96974651 | -89.76782777 | 2022-01-18 04:21:04 | Adams, Wisconsin, US | |
3690689 | 3690689 | 2022-01-13 | US | Texas | Robertson | 48395 | 3902 | 68 | 0 | 31.02539637 | -96.51272246 | 2022-01-14 04:21:54 | Robertson, Texas, US | |
1117080 | 1117080 | 2022-01-11 | US | West Virginia | Lewis | 54041 | 3902 | 68 | 0 | 38.9947249 | -80.49988181 | 2022-01-12 04:21:44 | Lewis, West Virginia, US | |
1693165 | 1693165 | 2022-01-10 | US | Georgia | Mitchell | 13205 | 3902 | 102 | 0 | 31.22483255 | -84.19381821 | 2022-01-11 04:22:01 | Mitchell, Georgia, US | |
1285539 | 1285539 | 2022-01-05 | US | Wisconsin | Green Lake | 55047 | 3902 | 49 | 0 | 43.80025981 | -89.04679553 | 2022-01-06 04:22:09 | Green Lake, Wisconsin, US | |
1289091 | 1289091 | 2022-01-04 | US | Texas | Fayette | 48149 | 3902 | 95 | 0 | 29.87788372 | -96.92076062 | 2022-01-05 04:21:59 | Fayette, Texas, US | |
2777539 | 2777539 | 2021-12-31 | US | California | Del Norte | 6015 | 3902 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2022-01-01 04:22:14 | Del Norte, California, US | |
801787 | 801787 | 2021-12-22 | US | Virginia | Hopewell | 51670 | 3902 | 96 | 0 | 37.29186313 | -77.29754684 | 2021-12-23 04:21:21 | Hopewell, Virginia, US | |
1661287 | 1661287 | 2021-12-12 | US | Georgia | Pike | 13231 | 3902 | 71 | 0 | 33.09310242 | -84.38790389 | 2021-12-13 04:22:02 | Pike, Georgia, US | |
1665927 | 1665927 | 2021-12-11 | US | Kentucky | Woodford | 21239 | 3902 | 33 | 0 | 38.04178222 | -84.7417556 | 2021-12-12 04:22:12 | Woodford, Kentucky, US | |
1665303 | 1665303 | 2021-12-11 | US | Georgia | Pike | 13231 | 3902 | 71 | 0 | 33.09310242 | -84.38790389 | 2021-12-12 04:22:12 | Pike, Georgia, US | |
3656455 | 3656455 | 2021-12-10 | US | Georgia | Pike | 13231 | 3902 | 71 | 0 | 33.09310242 | -84.38790389 | 2021-12-11 04:22:45 | Pike, Georgia, US | |
406148 | 406148 | 2021-12-07 | US | Mississippi | Tishomingo | 28141 | 3902 | 94 | 0 | 34.74023475 | -88.23917219 | 2021-12-08 04:22:46 | Tishomingo, Mississippi, US | |
1030487 | 1030487 | 2021-12-06 | Monaco | 3902 | 36 | 0 | 43.7333 | 7.4167 | 2021-12-07 04:22:34 | Monaco | ||||
1017806 | 1017806 | 2021-11-21 | US | West Virginia | Boone | 54005 | 3902 | 60 | 0 | 38.01974191 | -81.69888019 | 2021-11-22 04:22:20 | Boone, West Virginia, US | |
2290609 | 2290609 | 2021-11-15 | US | Texas | Lampasas | 48281 | 3902 | 68 | 0 | 31.19531316 | -98.24206613 | 2021-11-16 04:21:10 | Lampasas, Texas, US | |
1325383 | 1325383 | 2021-11-14 | US | Texas | Lampasas | 48281 | 3902 | 68 | 0 | 31.19531316 | -98.24206613 | 2021-11-15 04:21:36 | Lampasas, Texas, US | |
3643056 | 3643056 | 2021-11-08 | US | West Virginia | Nicholas | 54067 | 3902 | 51 | 0 | 38.29617706 | -80.79759588 | 2021-11-09 04:21:36 | Nicholas, West Virginia, US | |
700030 | 700030 | 2021-11-04 | US | Michigan | Chippewa | 26033 | 3902 | 52 | 0 | 46.29552653 | -84.54353449 | 2021-11-05 04:21:54 | Chippewa, Michigan, US | |
278554 | 278554 | 2021-11-03 | US | North Carolina | Transylvania | 37175 | 3902 | 48 | 0 | 35.20383864 | -82.79638423 | 2021-11-04 04:22:20 | Transylvania, North Carolina, US | |
277808 | 277808 | 2021-11-03 | US | Michigan | Chippewa | 26033 | 3902 | 52 | 0 | 46.29552653 | -84.54353449 | 2021-11-04 04:22:20 | Chippewa, Michigan, US | |
46513 | 46513 | 2021-11-02 | US | South Carolina | Barnwell | 45011 | 3902 | 84 | 0 | 33.26679302 | -81.43584352 | 2021-11-03 06:22:09 | Barnwell, South Carolina, US | |
45233 | 45233 | 2021-11-02 | US | Louisiana | Pointe Coupee | 22077 | 3902 | 83 | 0 | 30.71409502 | -91.60209535 | 2021-11-03 06:22:09 | Pointe Coupee, Louisiana, US | |
3514209 | 3514209 | 2021-11-01 | US | South Carolina | Barnwell | 45011 | 3902 | 84 | 0 | 33.26679302 | -81.43584352 | 2021-11-02 04:22:03 | Barnwell, South Carolina, US | |
3514027 | 3514027 | 2021-11-01 | US | Oregon | Jefferson | 41031 | 3902 | 57 | 0 | 44.62806839 | -121.17832 | 2021-11-02 04:22:03 | Jefferson, Oregon, US | |
536174 | 536174 | 2021-10-27 | US | Kentucky | Marion | 21155 | 3902 | 46 | 0 | 37.55218078 | -85.26898542 | 2021-10-28 04:22:08 | Marion, Kentucky, US | |
494461 | 494461 | 2021-10-14 | US | South Carolina | Jasper | 45053 | 3902 | 78 | 0 | 32.43171982 | -81.02487495 | 2021-10-15 04:21:26 | Jasper, South Carolina, US | |
635895 | 635895 | 2021-10-13 | US | Missouri | Stone | 29209 | 3902 | 85 | 0 | 36.75000327 | -93.45256475 | 2021-10-14 04:21:29 | Stone, Missouri, US | |
1336028 | 1336028 | 2021-09-28 | US | Minnesota | Pine | 27115 | 3902 | 27 | 0 | 46.12105238 | -92.74070188 | 2021-09-29 04:21:45 | Pine, Minnesota, US | |
3758328 | 3758328 | 2021-09-21 | US | Georgia | Peach | 13225 | 3902 | 82 | 0 | 32.56934316 | -83.82937 | 2021-09-22 04:21:45 | Peach, Georgia, US | |
2811678 | 2811678 | 2021-09-16 | US | Tennessee | DeKalb | 47041 | 3902 | 60 | 0 | 35.97616272 | -85.83689361 | 2021-09-17 04:21:46 | DeKalb, Tennessee, US | |
2809743 | 2809743 | 2021-09-16 | US | Illinois | Iroquois | 17075 | 3902 | 71 | 0 | 40.74717633 | -87.82466784 | 2021-09-17 04:21:46 | Iroquois, Illinois, US | |
2279540 | 2279540 | 2021-09-08 | US | Alabama | Lawrence | 1079 | 3902 | 100 | 0 | 34.52041498 | -87.31069453 | 2021-09-09 04:21:27 | Lawrence, Alabama, US | |
3195409 | 3195409 | 2021-09-06 | US | Kentucky | Harlan | 21095 | 3902 | 100 | 0 | 36.85699301 | -83.21899516 | 2021-09-07 04:21:35 | Harlan, Kentucky, US | |
67094 | 67094 | 2021-09-01 | Japan | Port Quarantine | 3902 | 6 | 0 | 2021-09-02 04:21:15 | Port Quarantine, Japan | |||||
3555694 | 3555694 | 2021-08-21 | Japan | Wakayama | 3902 | 51 | 0 | 33.911879 | 135.505446 | 2021-08-22 04:21:29 | Wakayama, Japan | |||
2354441 | 2354441 | 2021-08-10 | US | Tennessee | White | 47185 | 3902 | 75 | 0 | 35.92929884 | -85.45591799 | 2021-08-11 04:21:58 | White, Tennessee, US | |
650928 | 650928 | 2021-08-09 | US | Illinois | Bureau | 17011 | 3902 | 87 | 0 | 41.40385234 | -89.5283051 | 2021-08-10 04:21:27 | Bureau, Illinois, US | |
333033 | 333033 | 2021-08-04 | US | Indiana | Putnam | 18133 | 3902 | 62 | 0 | 39.66437981 | -86.84517605 | 2021-08-05 04:21:51 | Putnam, Indiana, US | |
3468703 | 3468703 | 2021-08-03 | US | Arkansas | St. Francis | 5123 | 3902 | 46 | 0 | 35.02201976 | -90.74828138 | 2021-08-04 04:21:25 | St. Francis, Arkansas, US | |
3388079 | 3388079 | 2021-07-29 | US | Pennsylvania | Perry | 42099 | 3902 | 101 | 0 | 40.40206612 | -77.26297447 | 2021-07-30 04:21:34 | Perry, Pennsylvania, US | |
408311 | 408311 | 2021-07-28 | Japan | Kagoshima | 3902 | 39 | 3760 | 103 | 31.009484000000004 | 130.430665 | 2021-07-29 04:21:33 | Kagoshima, Japan | ||
1309580 | 1309580 | 2021-07-27 | US | Virginia | York | 51199 | 3902 | 59 | 0 | 37.24374789 | -76.54412815 | 2021-07-28 04:21:39 | York, Virginia, US | |
485341 | 485341 | 2021-07-19 | US | Minnesota | Polk | 27119 | 3902 | 72 | 0 | 47.77372465 | -96.40134647 | 2021-07-20 04:21:48 | Polk, Minnesota, 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]);