johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,256 rows where confirmed = 145 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
544808 | 544808 | 2022-12-15 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-16 04:21:01 | Treasure, Montana, US | |
350336 | 350336 | 2022-12-14 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-15 04:20:58 | Treasure, Montana, US | |
309924 | 309924 | 2022-12-13 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-14 04:21:04 | Treasure, Montana, US | |
1150985 | 1150985 | 2022-12-12 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-11 23:21:04 | Treasure, Montana, US | |
870839 | 870839 | 2022-12-11 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-11 23:21:04 | Treasure, Montana, US | |
259369 | 259369 | 2022-12-10 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-11 04:20:50 | Treasure, Montana, US | |
3938083 | 3938083 | 2022-12-09 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-10 04:21:02 | Treasure, Montana, US | |
3379415 | 3379415 | 2022-12-08 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-09 04:21:05 | Treasure, Montana, US | |
1986686 | 1986686 | 2022-12-07 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-08 04:21:07 | Treasure, Montana, US | |
3716209 | 3716209 | 2022-12-06 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-07 04:20:58 | Treasure, Montana, US | |
2416914 | 2416914 | 2022-12-05 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-06 04:21:03 | Treasure, Montana, US | |
720522 | 720522 | 2022-12-04 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-05 04:20:58 | Treasure, Montana, US | |
2818811 | 2818811 | 2022-12-03 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-04 04:20:56 | Treasure, Montana, US | |
835667 | 835667 | 2022-12-02 | US | Montana | Treasure | 30103 | 145 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-03 04:21:02 | Treasure, Montana, US | |
900790 | 900790 | 2022-07-22 | US | Colorado | Hinsdale | 8053 | 145 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-07-23 04:20:53 | Hinsdale, Colorado, US | |
670926 | 670926 | 2022-07-21 | US | Colorado | Hinsdale | 8053 | 145 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-07-22 04:21:15 | Hinsdale, Colorado, US | |
1608889 | 1608889 | 2022-07-20 | US | Colorado | Hinsdale | 8053 | 145 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-07-21 04:21:10 | Hinsdale, Colorado, US | |
959522 | 959522 | 2022-07-19 | US | Colorado | Hinsdale | 8053 | 145 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-07-20 04:20:59 | Hinsdale, Colorado, US | |
3210909 | 3210909 | 2022-07-18 | US | Colorado | Hinsdale | 8053 | 145 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-07-19 04:20:58 | Hinsdale, Colorado, US | |
559468 | 559468 | 2022-06-16 | US | Colorado | Unassigned | 90008 | 145 | 0 | 0 | 40.87595412 | 0.0 | 2022-06-17 04:20:56 | Unassigned, Colorado, US | |
3983270 | 3983270 | 2022-06-15 | US | Colorado | Unassigned | 90008 | 145 | 0 | 0 | 40.87595412 | 0.0 | 2022-06-16 04:20:55 | Unassigned, Colorado, US | |
947511 | 947511 | 2022-06-14 | US | Colorado | Unassigned | 90008 | 145 | 0 | 0 | 40.87595412 | 0.0 | 2022-06-15 04:20:54 | Unassigned, Colorado, US | |
973309 | 973309 | 2022-06-01 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-06-02 05:20:39 | Billings, North Dakota, US | |
231616 | 231616 | 2022-05-31 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-06-01 04:20:55 | Billings, North Dakota, US | |
3188381 | 3188381 | 2022-05-30 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-31 04:20:51 | Billings, North Dakota, US | |
3200530 | 3200530 | 2022-05-29 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-30 04:20:50 | Billings, North Dakota, US | |
2727408 | 2727408 | 2022-05-28 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-29 04:20:53 | Billings, North Dakota, US | |
1316589 | 1316589 | 2022-05-27 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-28 04:21:07 | Billings, North Dakota, US | |
1852381 | 1852381 | 2022-05-26 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-27 04:20:56 | Billings, North Dakota, US | |
2050257 | 2050257 | 2022-05-25 | US | North Dakota | Billings | 38007 | 145 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-05-26 04:20:50 | Billings, North Dakota, US | |
261970 | 261970 | 2022-03-15 | US | Alaska | Skagway | 2230 | 145 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-03-16 04:20:50 | Skagway, Alaska, US | |
2264329 | 2264329 | 2022-03-14 | US | Alaska | Skagway | 2230 | 145 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-03-15 04:20:47 | Skagway, Alaska, US | |
2200569 | 2200569 | 2022-03-06 | US | Idaho | Camas | 16025 | 145 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-03-07 04:20:47 | Camas, Idaho, US | |
2093026 | 2093026 | 2022-03-05 | US | Idaho | Camas | 16025 | 145 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-03-06 04:20:49 | Camas, Idaho, US | |
2666726 | 2666726 | 2022-03-04 | US | Idaho | Camas | 16025 | 145 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-03-05 04:21:10 | Camas, Idaho, US | |
3821491 | 3821491 | 2022-02-16 | US | Illinois | Unassigned | 90017 | 145 | 3985 | 0 | 42.36542373 | 0.0 | 2022-02-17 04:20:56 | Unassigned, Illinois, US | |
3077207 | 3077207 | 2022-02-09 | US | Texas | Loving | 48301 | 145 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-02-10 04:21:14 | Loving, Texas, US | |
1365514 | 1365514 | 2022-02-08 | US | Texas | Loving | 48301 | 145 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-02-09 04:21:04 | Loving, Texas, US | |
73093 | 73093 | 2022-02-07 | US | Montana | Golden Valley | 30037 | 145 | 5 | 0 | 46.3816474 | -109.17685220000001 | 2022-02-08 04:21:15 | Golden Valley, Montana, US | |
2052510 | 2052510 | 2022-01-25 | US | Colorado | Jackson | 8057 | 145 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-01-26 04:21:07 | Jackson, Colorado, US | |
2836003 | 2836003 | 2022-01-22 | US | Texas | McMullen | 48311 | 145 | 8 | 0 | 28.35251708 | -98.56769164 | 2022-01-23 04:21:13 | McMullen, Texas, US | |
3428121 | 3428121 | 2022-01-21 | US | Texas | McMullen | 48311 | 145 | 8 | 0 | 28.35251708 | -98.56769164 | 2022-01-22 04:21:13 | McMullen, Texas, US | |
1663568 | 1663568 | 2021-12-12 | US | Texas | Kent | 48263 | 145 | 3 | 0 | 33.18104136 | -100.7780939 | 2021-12-13 04:22:02 | Kent, Texas, US | |
1662703 | 1662703 | 2021-12-12 | US | New York | Unassigned | 90036 | 145 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-13 04:22:02 | Unassigned, New York, US | |
1667584 | 1667584 | 2021-12-11 | US | Texas | Kent | 48263 | 145 | 3 | 0 | 33.18104136 | -100.7780939 | 2021-12-12 04:22:12 | Kent, Texas, US | |
1666719 | 1666719 | 2021-12-11 | US | New York | Unassigned | 90036 | 145 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-12 04:22:12 | Unassigned, New York, US | |
3658736 | 3658736 | 2021-12-10 | US | Texas | Kent | 48263 | 145 | 3 | 0 | 33.18104136 | -100.7780939 | 2021-12-11 04:22:45 | Kent, Texas, US | |
3657871 | 3657871 | 2021-12-10 | US | New York | Unassigned | 90036 | 145 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-11 04:22:45 | Unassigned, New York, US | |
1081067 | 1081067 | 2021-12-09 | US | Texas | Kent | 48263 | 145 | 3 | 0 | 33.18104136 | -100.7780939 | 2021-12-10 04:22:28 | Kent, Texas, US | |
1080202 | 1080202 | 2021-12-09 | US | New York | Unassigned | 90036 | 145 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-10 04:22:28 | Unassigned, New York, US | |
2607 | 2607 | 2021-12-02 | US | New York | Unassigned | 90036 | 145 | 2 | 0 | 44.74530905 | 0.0 | 2021-12-03 04:23:05 | Unassigned, New York, US | |
2290340 | 2290340 | 2021-11-15 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-16 04:21:10 | Jones, South Dakota, US | |
1325114 | 1325114 | 2021-11-14 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-15 04:21:36 | Jones, South Dakota, US | |
1322869 | 1322869 | 2021-11-14 | US | Colorado | Mineral | 8079 | 145 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2021-11-15 04:21:36 | Mineral, Colorado, US | |
689240 | 689240 | 2021-11-13 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-14 04:21:31 | Jones, South Dakota, US | |
686995 | 686995 | 2021-11-13 | US | Colorado | Mineral | 8079 | 145 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2021-11-14 04:21:31 | Mineral, Colorado, US | |
717349 | 717349 | 2021-11-12 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-13 04:21:38 | Jones, South Dakota, US | |
715104 | 715104 | 2021-11-12 | US | Colorado | Mineral | 8079 | 145 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2021-11-13 04:21:38 | Mineral, Colorado, US | |
31299 | 31299 | 2021-11-11 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-12 04:22:01 | Jones, South Dakota, US | |
2847738 | 2847738 | 2021-11-10 | US | South Dakota | Jones | 46075 | 145 | 1 | 0 | 43.96278565 | -100.6940008 | 2021-11-11 04:21:45 | Jones, South Dakota, US | |
537832 | 537832 | 2021-10-27 | US | Texas | Glasscock | 48173 | 145 | 3 | 0 | 31.86942909 | -101.5207776 | 2021-10-28 04:22:08 | Glasscock, Texas, US | |
3495269 | 3495269 | 2021-10-26 | US | Texas | Glasscock | 48173 | 145 | 3 | 0 | 31.86942909 | -101.5207776 | 2021-10-27 04:22:32 | Glasscock, Texas, US | |
3796991 | 3796991 | 2021-10-25 | US | Texas | Glasscock | 48173 | 145 | 3 | 0 | 31.86942909 | -101.5207776 | 2021-10-26 04:22:09 | Glasscock, Texas, US | |
685437 | 685437 | 2021-10-24 | US | Texas | Glasscock | 48173 | 145 | 3 | 0 | 31.86942909 | -101.5207776 | 2021-10-25 04:22:31 | Glasscock, Texas, US | |
682781 | 682781 | 2021-10-24 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-25 04:22:31 | Wrangell, Alaska, US | |
773445 | 773445 | 2021-10-23 | US | Texas | Glasscock | 48173 | 145 | 3 | 0 | 31.86942909 | -101.5207776 | 2021-10-24 04:21:22 | Glasscock, Texas, US | |
770789 | 770789 | 2021-10-23 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-24 04:21:22 | Wrangell, Alaska, US | |
654436 | 654436 | 2021-10-22 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-23 04:21:32 | Wrangell, Alaska, US | |
2124183 | 2124183 | 2021-10-21 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-22 04:21:14 | Wrangell, Alaska, US | |
443795 | 443795 | 2021-10-20 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-21 04:21:18 | Wrangell, Alaska, US | |
598114 | 598114 | 2021-10-19 | US | Alaska | Wrangell | 2275 | 145 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-20 04:21:00 | Wrangell, Alaska, US | |
494270 | 494270 | 2021-10-14 | US | Oregon | Sherman | 41055 | 145 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-10-15 04:21:26 | Sherman, Oregon, US | |
636558 | 636558 | 2021-10-13 | US | Oregon | Sherman | 41055 | 145 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-10-14 04:21:29 | Sherman, Oregon, US | |
1494236 | 1494236 | 2021-10-12 | US | Oregon | Sherman | 41055 | 145 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-10-13 04:20:51 | Sherman, Oregon, US | |
989164 | 989164 | 2021-10-04 | US | New Mexico | Catron | 35003 | 145 | 7 | 0 | 33.91514144 | -108.4046587 | 2021-10-05 04:21:27 | Catron, New Mexico, US | |
3928624 | 3928624 | 2021-10-02 | US | California | Sierra | 6091 | 145 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-03 04:21:24 | Sierra, California, US | |
2132604 | 2132604 | 2021-10-01 | US | California | Sierra | 6091 | 145 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-02 04:21:25 | Sierra, California, US | |
2775052 | 2775052 | 2021-09-30 | US | Nebraska | Garden | 31069 | 145 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-10-01 04:21:35 | Garden, Nebraska, US | |
2773561 | 2773561 | 2021-09-30 | US | California | Sierra | 6091 | 145 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-01 04:21:35 | Sierra, California, US | |
708508 | 708508 | 2021-09-29 | US | Nebraska | Garden | 31069 | 145 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-09-30 04:21:20 | Garden, Nebraska, US | |
1887876 | 1887876 | 2021-09-12 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-13 04:21:15 | Hyde, South Dakota, US | |
3808779 | 3808779 | 2021-09-11 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-12 04:21:13 | Hyde, South Dakota, US | |
3451927 | 3451927 | 2021-09-10 | US | Texas | Foard | 48155 | 145 | 10 | 0 | 33.97308618 | -99.7767797 | 2021-09-11 04:21:30 | Foard, Texas, US | |
3451719 | 3451719 | 2021-09-10 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-11 04:21:30 | Hyde, South Dakota, US | |
1265873 | 1265873 | 2021-09-09 | US | Texas | Foard | 48155 | 145 | 10 | 0 | 33.97308618 | -99.7767797 | 2021-09-10 04:21:20 | Foard, Texas, US | |
1265665 | 1265665 | 2021-09-09 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-10 04:21:20 | Hyde, South Dakota, US | |
1264093 | 1264093 | 2021-09-09 | US | Kansas | Lane | 20101 | 145 | 7 | 0 | 38.48119447 | -100.46607540000001 | 2021-09-10 04:21:20 | Lane, Kansas, US | |
2282035 | 2282035 | 2021-09-08 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-09 04:21:27 | Hyde, South Dakota, US | |
2280463 | 2280463 | 2021-09-08 | US | Kansas | Lane | 20101 | 145 | 7 | 0 | 38.48119447 | -100.46607540000001 | 2021-09-09 04:21:27 | Lane, Kansas, US | |
2279581 | 2279581 | 2021-09-08 | US | Alaska | Haines | 2100 | 145 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-09-09 04:21:27 | Haines, Alaska, US | |
644814 | 644814 | 2021-09-07 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-08 04:21:31 | Hyde, South Dakota, US | |
644790 | 644790 | 2021-09-07 | US | South Dakota | Campbell | 46021 | 145 | 4 | 0 | 45.77074915 | -100.0510181 | 2021-09-08 04:21:31 | Campbell, South Dakota, US | |
642360 | 642360 | 2021-09-07 | US | Alaska | Haines | 2100 | 145 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-09-08 04:21:31 | Haines, Alaska, US | |
3196877 | 3196877 | 2021-09-06 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-07 04:21:35 | Hyde, South Dakota, US | |
3196853 | 3196853 | 2021-09-06 | US | South Dakota | Campbell | 46021 | 145 | 4 | 0 | 45.77074915 | -100.0510181 | 2021-09-07 04:21:35 | Campbell, South Dakota, US | |
3194604 | 3194604 | 2021-09-06 | US | Colorado | Cheyenne | 8017 | 145 | 7 | 0 | 38.82777431 | -102.6032558 | 2021-09-07 04:21:35 | Cheyenne, Colorado, US | |
3283745 | 3283745 | 2021-09-05 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-06 04:21:22 | Hyde, South Dakota, US | |
3283721 | 3283721 | 2021-09-05 | US | South Dakota | Campbell | 46021 | 145 | 4 | 0 | 45.77074915 | -100.0510181 | 2021-09-06 04:21:22 | Campbell, South Dakota, US | |
3281472 | 3281472 | 2021-09-05 | US | Colorado | Cheyenne | 8017 | 145 | 7 | 0 | 38.82777431 | -102.6032558 | 2021-09-06 04:21:22 | Cheyenne, Colorado, US | |
252159 | 252159 | 2021-09-04 | US | South Dakota | Hyde | 46069 | 145 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-09-05 04:21:33 | Hyde, South Dakota, 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]);