johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
899 rows where confirmed = 318 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755526 | 2755526 | 2022-12-29 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-30 04:21:04 | Gilliam, Oregon, US | |
1076532 | 1076532 | 2022-12-28 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-29 04:21:01 | Gilliam, Oregon, US | |
2017606 | 2017606 | 2022-09-20 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-21 04:23:22 | Taliaferro, Georgia, US | |
3571479 | 3571479 | 2022-09-19 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-20 04:22:48 | Taliaferro, Georgia, US | |
420218 | 420218 | 2022-09-18 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-19 04:21:49 | Taliaferro, Georgia, US | |
3374242 | 3374242 | 2022-09-17 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-18 04:22:50 | Taliaferro, Georgia, US | |
2356350 | 2356350 | 2022-09-16 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-17 04:20:19 | Taliaferro, Georgia, US | |
3987507 | 3987507 | 2022-09-15 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-16 04:21:19 | Taliaferro, Georgia, US | |
1890024 | 1890024 | 2022-09-14 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-15 04:21:02 | Taliaferro, Georgia, US | |
373079 | 373079 | 2022-09-13 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-14 04:20:44 | Taliaferro, Georgia, US | |
2395681 | 2395681 | 2022-09-12 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-13 04:20:57 | Taliaferro, Georgia, US | |
3766759 | 3766759 | 2022-09-11 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-12 04:20:58 | Taliaferro, Georgia, US | |
3825334 | 3825334 | 2022-09-10 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-11 04:20:50 | Taliaferro, Georgia, US | |
963791 | 963791 | 2022-09-09 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-10 04:21:10 | Taliaferro, Georgia, US | |
254193 | 254193 | 2022-09-08 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-09 04:21:11 | Taliaferro, Georgia, US | |
3745991 | 3745991 | 2022-09-07 | US | Georgia | Taliaferro | 13265 | 318 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-08 04:21:02 | Taliaferro, Georgia, US | |
2831978 | 2831978 | 2022-08-25 | US | Texas | Loving | 48301 | 318 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-26 04:21:02 | Loving, Texas, US | |
2326511 | 2326511 | 2022-08-24 | US | Texas | Loving | 48301 | 318 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-25 04:21:13 | Loving, Texas, US | |
1253920 | 1253920 | 2022-08-23 | US | Texas | Loving | 48301 | 318 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-24 04:20:46 | Loving, Texas, US | |
2856024 | 2856024 | 2022-08-22 | US | Texas | Loving | 48301 | 318 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-23 04:20:56 | Loving, Texas, US | |
1087385 | 1087385 | 2022-08-09 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-10 04:20:57 | Lane, Kansas, US | |
3544800 | 3544800 | 2022-08-08 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-09 04:20:34 | Lane, Kansas, US | |
1071203 | 1071203 | 2022-08-07 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-08 04:21:08 | Lane, Kansas, US | |
1941791 | 1941791 | 2022-08-06 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-07 04:20:54 | Lane, Kansas, US | |
881590 | 881590 | 2022-08-05 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-06 04:20:56 | Lane, Kansas, US | |
2010001 | 2010001 | 2022-08-04 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-05 04:20:52 | Lane, Kansas, US | |
1099428 | 1099428 | 2022-08-03 | US | Kansas | Lane | 20101 | 318 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-08-04 04:20:58 | Lane, Kansas, US | |
1490468 | 1490468 | 2022-07-26 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-27 04:21:04 | Hyde, South Dakota, US | |
2596914 | 2596914 | 2022-07-25 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-26 04:20:58 | Hyde, South Dakota, US | |
899029 | 899029 | 2022-07-24 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-25 04:20:51 | Hyde, South Dakota, US | |
94023 | 94023 | 2022-07-23 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-24 04:20:47 | Hyde, South Dakota, US | |
903045 | 903045 | 2022-07-22 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-23 04:20:53 | Hyde, South Dakota, US | |
673181 | 673181 | 2022-07-21 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-22 04:21:15 | Hyde, South Dakota, US | |
1611144 | 1611144 | 2022-07-20 | US | South Dakota | Hyde | 46069 | 318 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-07-21 04:21:10 | Hyde, South Dakota, US | |
2981324 | 2981324 | 2022-06-13 | US | Nebraska | Deuel | 31049 | 318 | 2 | 0 | 41.11168186 | -102.3333331 | 2022-06-14 04:20:52 | Deuel, Nebraska, US | |
2237450 | 2237450 | 2022-06-12 | US | Nebraska | Deuel | 31049 | 318 | 2 | 0 | 41.11168186 | -102.3333331 | 2022-06-13 04:21:14 | Deuel, Nebraska, US | |
3143648 | 3143648 | 2022-06-11 | US | Nebraska | Deuel | 31049 | 318 | 2 | 0 | 41.11168186 | -102.3333331 | 2022-06-12 04:20:53 | Deuel, Nebraska, US | |
1946564 | 1946564 | 2022-06-10 | US | Nebraska | Deuel | 31049 | 318 | 2 | 0 | 41.11168186 | -102.3333331 | 2022-06-11 04:21:01 | Deuel, Nebraska, US | |
973658 | 973658 | 2022-06-01 | US | Puerto Rico | Culebra | 72049 | 318 | 0 | 0 | 18.31586 | -65.28813 | 2022-06-02 05:20:39 | Culebra, Puerto Rico, US | |
466458 | 466458 | 2022-05-02 | US | Texas | Cottle | 48101 | 318 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-05-03 04:21:00 | Cottle, Texas, US | |
3919097 | 3919097 | 2022-05-01 | US | Texas | Cottle | 48101 | 318 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-05-02 04:21:10 | Cottle, Texas, US | |
2843901 | 2843901 | 2022-04-30 | US | Texas | Cottle | 48101 | 318 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-05-01 04:20:57 | Cottle, Texas, US | |
1848611 | 1848611 | 2022-04-18 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-19 04:21:00 | Sherman, Oregon, US | |
3419555 | 3419555 | 2022-04-17 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-18 04:21:12 | Sherman, Oregon, US | |
306504 | 306504 | 2022-04-16 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-17 04:20:59 | Sherman, Oregon, US | |
2672449 | 2672449 | 2022-04-15 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-16 04:20:48 | Sherman, Oregon, US | |
1226234 | 1226234 | 2022-04-14 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-15 04:20:57 | Sherman, Oregon, US | |
2445392 | 2445392 | 2022-04-13 | US | Oregon | Sherman | 41055 | 318 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-04-13 23:21:06 | Sherman, Oregon, US | |
3870181 | 3870181 | 2022-04-05 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-06 04:20:49 | Sherman, Oregon, US | |
2751523 | 2751523 | 2022-04-04 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-05 04:20:48 | Sherman, Oregon, US | |
3732869 | 3732869 | 2022-04-03 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-04 04:20:51 | Sherman, Oregon, US | |
502304 | 502304 | 2022-04-02 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-03 04:20:48 | Sherman, Oregon, US | |
3353289 | 3353289 | 2022-04-01 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-02 04:20:47 | Sherman, Oregon, US | |
1542594 | 1542594 | 2022-03-31 | US | Oregon | Sherman | 41055 | 318 | 5 | 0 | 45.41501554 | -120.6827834 | 2022-04-01 04:20:28 | Sherman, Oregon, US | |
3912627 | 3912627 | 2022-02-20 | US | Colorado | Cheyenne | 8017 | 318 | 9 | 0 | 38.82777431 | -102.6032558 | 2022-02-21 04:21:05 | Cheyenne, Colorado, US | |
3876185 | 3876185 | 2022-02-19 | US | Colorado | Cheyenne | 8017 | 318 | 9 | 0 | 38.82777431 | -102.6032558 | 2022-02-20 04:21:00 | Cheyenne, Colorado, US | |
3856441 | 3856441 | 2022-02-18 | US | Colorado | Cheyenne | 8017 | 318 | 9 | 0 | 38.82777431 | -102.6032558 | 2022-02-19 04:21:11 | Cheyenne, Colorado, US | |
1298660 | 1298660 | 2022-02-17 | US | Colorado | Cheyenne | 8017 | 318 | 9 | 0 | 38.82777431 | -102.6032558 | 2022-02-18 04:21:04 | Cheyenne, Colorado, US | |
73508 | 73508 | 2022-02-07 | US | North Dakota | Oliver | 38065 | 318 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-08 04:21:15 | Oliver, North Dakota, US | |
2015124 | 2015124 | 2022-02-06 | US | North Dakota | Oliver | 38065 | 318 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-07 04:21:05 | Oliver, North Dakota, US | |
1296453 | 1296453 | 2022-02-05 | US | North Dakota | Oliver | 38065 | 318 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-06 04:21:00 | Oliver, North Dakota, US | |
2329781 | 2329781 | 2022-02-04 | US | North Dakota | Oliver | 38065 | 318 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-05 04:21:05 | Oliver, North Dakota, US | |
2476372 | 2476372 | 2022-02-03 | US | North Dakota | Oliver | 38065 | 318 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-04 04:21:10 | Oliver, North Dakota, US | |
1780680 | 1780680 | 2022-01-27 | US | Kansas | Greeley | 20071 | 318 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-01-28 04:21:09 | Greeley, Kansas, US | |
1320290 | 1320290 | 2022-01-26 | US | Nebraska | Garden | 31069 | 318 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-01-27 04:21:19 | Garden, Nebraska, US | |
1319508 | 1319508 | 2022-01-26 | US | Kansas | Greeley | 20071 | 318 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-01-27 04:21:19 | Greeley, Kansas, US | |
2055324 | 2055324 | 2022-01-25 | US | Washington | Garfield | 53023 | 318 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2022-01-26 04:21:07 | Garfield, Washington, US | |
1231055 | 1231055 | 2022-01-24 | US | Washington | Garfield | 53023 | 318 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2022-01-25 04:21:05 | Garfield, Washington, US | |
1960978 | 1960978 | 2022-01-20 | US | Alaska | Denali | 2068 | 318 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-21 04:21:09 | Denali, Alaska, US | |
3226873 | 3226873 | 2022-01-19 | US | Alaska | Denali | 2068 | 318 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-20 04:21:07 | Denali, Alaska, US | |
3464618 | 3464618 | 2022-01-18 | US | Alaska | Wrangell | 2275 | 318 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-01-19 04:21:23 | Wrangell, Alaska, US | |
1474109 | 1474109 | 2022-01-17 | US | Montana | Daniels | 30019 | 318 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-18 04:21:04 | Daniels, Montana, US | |
1472557 | 1472557 | 2022-01-17 | US | Alaska | Wrangell | 2275 | 318 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-01-18 04:21:04 | Wrangell, Alaska, US | |
556783 | 556783 | 2022-01-16 | US | Montana | Daniels | 30019 | 318 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-17 04:21:08 | Daniels, Montana, US | |
555231 | 555231 | 2022-01-16 | US | Alaska | Wrangell | 2275 | 318 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-01-17 04:21:08 | Wrangell, Alaska, US | |
3842941 | 3842941 | 2022-01-15 | US | North Dakota | Steele | 38091 | 318 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-01-16 04:21:12 | Steele, North Dakota, US | |
3842504 | 3842504 | 2022-01-15 | US | Montana | Daniels | 30019 | 318 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-16 04:21:12 | Daniels, Montana, US | |
3840952 | 3840952 | 2022-01-15 | US | Alaska | Wrangell | 2275 | 318 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-01-16 04:21:12 | Wrangell, Alaska, US | |
101319 | 101319 | 2022-01-14 | US | Montana | Daniels | 30019 | 318 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-15 04:21:07 | Daniels, Montana, US | |
99767 | 99767 | 2022-01-14 | US | Alaska | Wrangell | 2275 | 318 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-01-15 04:21:07 | Wrangell, Alaska, US | |
3689474 | 3689474 | 2022-01-13 | US | Montana | Daniels | 30019 | 318 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-14 04:21:54 | Daniels, Montana, US | |
130198 | 130198 | 2022-01-09 | US | Washington | Wahkiakum | 53069 | 318 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-10 04:22:07 | Wahkiakum, Washington, US | |
1219033 | 1219033 | 2022-01-08 | US | Washington | Wahkiakum | 53069 | 318 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-09 04:21:46 | Wahkiakum, Washington, US | |
1393126 | 1393126 | 2022-01-07 | US | Washington | Wahkiakum | 53069 | 318 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-08 04:21:53 | Wahkiakum, Washington, US | |
1288082 | 1288082 | 2022-01-04 | US | Nebraska | Garfield | 31071 | 318 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-05 04:21:59 | Garfield, Nebraska, US | |
1702332 | 1702332 | 2022-01-03 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-04 04:22:17 | Worth, Missouri, US | |
3521415 | 3521415 | 2022-01-02 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-03 02:22:25 | Worth, Missouri, US | |
2169545 | 2169545 | 2022-01-01 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-02 04:20:52 | Worth, Missouri, US | |
2778976 | 2778976 | 2021-12-31 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-01 04:22:14 | Worth, Missouri, US | |
4000633 | 4000633 | 2021-12-30 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2021-12-31 04:21:50 | Worth, Missouri, US | |
1670440 | 1670440 | 2021-12-29 | US | Missouri | Worth | 29227 | 318 | 3 | 0 | 40.47945588 | -94.42328751 | 2021-12-30 04:21:25 | Worth, Missouri, US | |
801503 | 801503 | 2021-12-22 | US | Texas | Dickens | 48125 | 318 | 15 | 0 | 33.61616822 | -100.7788855 | 2021-12-23 04:21:21 | Dickens, Texas, US | |
1718462 | 1718462 | 2021-12-16 | US | Nebraska | Pawnee | 31133 | 318 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-12-17 04:22:14 | Pawnee, Nebraska, US | |
3498296 | 3498296 | 2021-12-15 | US | Nebraska | Pawnee | 31133 | 318 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-12-16 04:22:11 | Pawnee, Nebraska, US | |
2090081 | 2090081 | 2021-12-14 | US | Nebraska | Pawnee | 31133 | 318 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-12-15 03:22:16 | Pawnee, Nebraska, US | |
1663308 | 1663308 | 2021-12-12 | US | South Dakota | Jerauld | 46073 | 318 | 18 | 0 | 44.06637798 | -98.62965972 | 2021-12-13 04:22:02 | Jerauld, South Dakota, US | |
1667324 | 1667324 | 2021-12-11 | US | South Dakota | Jerauld | 46073 | 318 | 18 | 0 | 44.06637798 | -98.62965972 | 2021-12-12 04:22:12 | Jerauld, South Dakota, US | |
3658476 | 3658476 | 2021-12-10 | US | South Dakota | Jerauld | 46073 | 318 | 18 | 0 | 44.06637798 | -98.62965972 | 2021-12-11 04:22:45 | Jerauld, South Dakota, US | |
3403837 | 3403837 | 2021-11-30 | US | North Dakota | Divide | 38023 | 318 | 3 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-12-01 04:22:29 | Divide, North Dakota, US | |
1233822 | 1233822 | 2021-11-28 | US | New Mexico | De Baca | 35011 | 318 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-11-29 04:22:30 | De Baca, New Mexico, 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]);