johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
367 rows where confirmed = 1550 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176202 | 3176202 | 2022-12-19 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-20 04:21:04 | McHenry, North Dakota, US | |
1630719 | 1630719 | 2022-12-18 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-19 04:21:03 | McHenry, North Dakota, US | |
506098 | 506098 | 2022-12-17 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-18 04:21:03 | McHenry, North Dakota, US | |
480935 | 480935 | 2022-11-08 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-09 04:21:22 | Rooks, Kansas, US | |
2440085 | 2440085 | 2022-11-07 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-08 04:21:21 | Rooks, Kansas, US | |
1051183 | 1051183 | 2022-11-06 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-07 04:21:26 | Rooks, Kansas, US | |
619207 | 619207 | 2022-11-05 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-06 04:21:24 | Rooks, Kansas, US | |
1023711 | 1023711 | 2022-11-04 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-05 04:21:52 | Rooks, Kansas, US | |
432702 | 432702 | 2022-11-03 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-04 04:22:11 | Rooks, Kansas, US | |
850944 | 850944 | 2022-11-02 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-03 04:22:05 | Rooks, Kansas, US | |
1831490 | 1831490 | 2022-10-25 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-26 04:22:19 | Phillips, Kansas, US | |
795751 | 795751 | 2022-10-24 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-25 04:21:53 | Phillips, Kansas, US | |
3278206 | 3278206 | 2022-10-23 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-24 04:22:29 | Phillips, Kansas, US | |
2269244 | 2269244 | 2022-10-22 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-23 04:22:46 | Phillips, Kansas, US | |
1593544 | 1593544 | 2022-10-21 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-22 04:22:53 | Phillips, Kansas, US | |
2273260 | 2273260 | 2022-10-20 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-21 04:22:23 | Phillips, Kansas, US | |
199595 | 199595 | 2022-10-19 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-20 04:22:59 | Phillips, Kansas, US | |
2758256 | 2758256 | 2022-10-18 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-19 04:22:26 | Phillips, Kansas, US | |
2026090 | 2026090 | 2022-10-17 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-18 04:22:42 | Phillips, Kansas, US | |
2160868 | 2160868 | 2022-10-16 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-17 04:20:31 | Phillips, Kansas, US | |
517065 | 517065 | 2022-10-15 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-16 04:22:39 | Phillips, Kansas, US | |
2034122 | 2034122 | 2022-10-14 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-15 04:22:00 | Phillips, Kansas, US | |
3754810 | 3754810 | 2022-10-13 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-14 04:22:28 | Phillips, Kansas, US | |
3215635 | 3215635 | 2022-10-12 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-13 04:22:39 | Phillips, Kansas, US | |
2262945 | 2262945 | 2022-10-02 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-03 04:23:11 | Mills, Texas, US | |
2998471 | 2998471 | 2022-10-01 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-02 04:21:23 | Mills, Texas, US | |
856797 | 856797 | 2022-09-30 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-01 04:23:01 | Mills, Texas, US | |
2406219 | 2406219 | 2022-08-21 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-22 04:20:38 | Norton, Virginia, US | |
3801297 | 3801297 | 2022-08-20 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-21 04:20:44 | Norton, Virginia, US | |
2366883 | 2366883 | 2022-08-19 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-20 04:21:01 | Norton, Virginia, US | |
1073222 | 1073222 | 2022-08-07 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-08 04:21:08 | Cumberland, Virginia, US | |
1943810 | 1943810 | 2022-08-06 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-07 04:20:54 | Cumberland, Virginia, US | |
883609 | 883609 | 2022-08-05 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-06 04:20:56 | Cumberland, Virginia, US | |
1066809 | 1066809 | 2022-07-28 | US | Idaho | Caribou | 16029 | 1550 | 27 | 0 | 42.77149116 | -111.5597683 | 2022-07-29 04:20:45 | Caribou, Idaho, US | |
2336328 | 2336328 | 2022-07-27 | US | Idaho | Caribou | 16029 | 1550 | 27 | 0 | 42.77149116 | -111.5597683 | 2022-07-28 04:20:56 | Caribou, Idaho, US | |
2421287 | 2421287 | 2022-07-15 | US | North Dakota | Dickey | 38021 | 1550 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-07-16 04:21:05 | Dickey, North Dakota, US | |
2744565 | 2744565 | 2022-07-07 | US | Wisconsin | Iron | 55051 | 1550 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-07-08 04:20:56 | Iron, Wisconsin, US | |
1201530 | 1201530 | 2022-07-06 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-07 04:20:55 | Grant, Minnesota, US | |
3968273 | 3968273 | 2022-07-05 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-06 04:20:58 | Grant, Minnesota, US | |
3967905 | 3967905 | 2022-07-05 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-06 04:20:58 | Stevens, Kansas, US | |
3079784 | 3079784 | 2022-07-04 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-05 04:20:45 | Grant, Minnesota, US | |
3079416 | 3079416 | 2022-07-04 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-05 04:20:45 | Stevens, Kansas, US | |
1769066 | 1769066 | 2022-07-03 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-04 04:20:54 | Grant, Minnesota, US | |
1768698 | 1768698 | 2022-07-03 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-04 04:20:54 | Stevens, Kansas, US | |
3367052 | 3367052 | 2022-07-02 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-03 04:20:59 | Grant, Minnesota, US | |
3366684 | 3366684 | 2022-07-02 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-03 04:20:59 | Stevens, Kansas, US | |
595381 | 595381 | 2022-07-01 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-02 04:21:16 | Grant, Minnesota, US | |
595013 | 595013 | 2022-07-01 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-02 04:21:16 | Stevens, Kansas, US | |
3941782 | 3941782 | 2022-06-30 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-01 04:21:10 | Grant, Minnesota, US | |
3941414 | 3941414 | 2022-06-30 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-01 04:21:10 | Stevens, Kansas, US | |
2493148 | 2493148 | 2022-06-29 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-30 04:21:01 | Jack, Texas, US | |
2491740 | 2491740 | 2022-06-29 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-06-30 04:21:01 | Grant, Minnesota, US | |
2491372 | 2491372 | 2022-06-29 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-30 04:21:01 | Stevens, Kansas, US | |
2490645 | 2490645 | 2022-06-29 | US | Colorado | Huerfano | 8055 | 1550 | 37 | 0 | 37.68473101 | -104.9612585 | 2022-06-30 04:21:01 | Huerfano, Colorado, US | |
2490610 | 2490610 | 2022-06-29 | US | California | Trinity | 6105 | 1550 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-30 04:21:01 | Trinity, California, US | |
2242530 | 2242530 | 2022-06-28 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-29 04:20:59 | Jack, Texas, US | |
2150772 | 2150772 | 2022-06-27 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-28 04:20:58 | Jack, Texas, US | |
478573 | 478573 | 2022-06-26 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-27 04:21:00 | Jack, Texas, US | |
167230 | 167230 | 2022-06-21 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-22 04:20:54 | Decatur, Iowa, US | |
1764513 | 1764513 | 2022-06-20 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-21 04:20:56 | Decatur, Iowa, US | |
3270699 | 3270699 | 2022-06-19 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-20 04:21:01 | Decatur, Iowa, US | |
3398611 | 3398611 | 2022-06-18 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-19 04:20:51 | Decatur, Iowa, US | |
2312488 | 2312488 | 2022-06-17 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-18 04:21:10 | Decatur, Iowa, US | |
559992 | 559992 | 2022-06-16 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-17 04:20:56 | Decatur, Iowa, US | |
3983794 | 3983794 | 2022-06-15 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-16 04:20:55 | Decatur, Iowa, US | |
3002766 | 3002766 | 2022-05-24 | US | Washington | Skamania | 53059 | 1550 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-25 04:20:56 | Skamania, Washington, US | |
3000274 | 3000274 | 2022-05-24 | US | Illinois | Calhoun | 17013 | 1550 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-25 04:20:56 | Calhoun, Illinois, US | |
3596487 | 3596487 | 2022-05-23 | US | Washington | Skamania | 53059 | 1550 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-24 04:20:57 | Skamania, Washington, US | |
3594777 | 3594777 | 2022-05-23 | US | Minnesota | Norman | 27107 | 1550 | 14 | 0 | 47.32628443 | -96.45620947 | 2022-05-24 04:20:57 | Norman, Minnesota, US | |
2141633 | 2141633 | 2022-03-09 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-10 04:20:48 | Owsley, Kentucky, US | |
921144 | 921144 | 2022-03-08 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-09 04:20:59 | Owsley, Kentucky, US | |
1549431 | 1549431 | 2022-03-07 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-08 04:20:54 | Owsley, Kentucky, US | |
2201100 | 2201100 | 2022-03-06 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-07 04:20:47 | Owsley, Kentucky, US | |
2093557 | 2093557 | 2022-03-05 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-06 04:20:49 | Owsley, Kentucky, US | |
2667257 | 2667257 | 2022-03-04 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-05 04:21:10 | Owsley, Kentucky, US | |
3672811 | 3672811 | 2022-02-15 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-16 04:21:10 | Adair, Iowa, US | |
2642912 | 2642912 | 2022-02-14 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-15 04:21:09 | Adair, Iowa, US | |
188000 | 188000 | 2022-02-13 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-14 04:20:51 | Maries, Missouri, US | |
187229 | 187229 | 2022-02-13 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-14 04:20:51 | Adair, Iowa, US | |
317846 | 317846 | 2022-02-12 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-13 04:21:00 | Maries, Missouri, US | |
317075 | 317075 | 2022-02-12 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-13 04:21:00 | Adair, Iowa, US | |
235172 | 235172 | 2022-02-11 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-12 04:21:06 | Maries, Missouri, US | |
234401 | 234401 | 2022-02-11 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-12 04:21:06 | Adair, Iowa, US | |
1466014 | 1466014 | 2022-02-10 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-11 04:21:09 | Maries, Missouri, US | |
1465865 | 1465865 | 2022-02-10 | US | Minnesota | Wilkin | 27167 | 1550 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-02-11 04:21:09 | Wilkin, Minnesota, US | |
1465243 | 1465243 | 2022-02-10 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-11 04:21:09 | Adair, Iowa, US | |
3075204 | 3075204 | 2022-02-09 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-10 04:21:14 | Adair, Iowa, US | |
2330416 | 2330416 | 2022-02-04 | US | Texas | Coleman | 48083 | 1550 | 65 | 0 | 31.76736834 | -99.45240766 | 2022-02-05 04:21:05 | Coleman, Texas, US | |
2054991 | 2054991 | 2022-01-25 | US | Texas | Hansford | 48195 | 1550 | 27 | 0 | 36.27743284 | -101.3545796 | 2022-01-26 04:21:07 | Hansford, Texas, US | |
2053984 | 2053984 | 2022-01-25 | US | Nebraska | Merrick | 31121 | 1550 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-26 04:21:07 | Merrick, Nebraska, US | |
1474176 | 1474176 | 2022-01-17 | US | Nebraska | Cuming | 31039 | 1550 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-01-18 04:21:04 | Cuming, Nebraska, US | |
3690221 | 3690221 | 2022-01-13 | US | Puerto Rico | Florida | 72054 | 1550 | 0 | 0 | 18.373715 | -66.560488 | 2022-01-14 04:21:54 | Florida, Puerto Rico, US | |
3616129 | 3616129 | 2022-01-12 | US | Texas | Crosby | 48107 | 1550 | 42 | 0 | 33.61431553 | -101.30003640000001 | 2022-01-13 08:00:09 | Crosby, Texas, US | |
1114115 | 1114115 | 2022-01-11 | US | Arkansas | Searcy | 5129 | 1550 | 33 | 0 | 35.9109364 | -92.69936482 | 2022-01-12 04:21:44 | Searcy, Arkansas, US | |
2610445 | 2610445 | 2022-01-06 | US | Alabama | Perry | 1105 | 1550 | 41 | 0 | 32.64048341 | -87.29770589 | 2022-01-07 04:22:09 | Perry, Alabama, US | |
1285507 | 1285507 | 2022-01-05 | US | West Virginia | Tyler | 54095 | 1550 | 26 | 0 | 39.46811972 | -80.88772676 | 2022-01-06 04:22:09 | Tyler, West Virginia, US | |
1289527 | 1289527 | 2022-01-04 | US | West Virginia | Webster | 54101 | 1550 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-05 04:21:59 | Webster, West Virginia, US | |
3831976 | 3831976 | 2021-12-21 | US | West Virginia | Pleasants | 54073 | 1550 | 31 | 0 | 39.37091679 | -81.16771771 | 2021-12-22 04:21:54 | Pleasants, West Virginia, US | |
3831950 | 3831950 | 2021-12-21 | US | West Virginia | Gilmer | 54021 | 1550 | 15 | 0 | 38.9251277 | -80.85952723 | 2021-12-22 04:21:54 | Gilmer, West Virginia, US | |
2198346 | 2198346 | 2021-12-03 | US | Puerto Rico | Barranquitas | 72019 | 1550 | 0 | 0 | 18.201592 | -66.30963 | 2021-12-04 04:22:18 | Barranquitas, Puerto Rico, 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]);