johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,123 rows where confirmed = 175 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 170
- Georgia 56
- Colorado 48
- Kansas 46
- Virginia 46
- Montana 45
- Missouri 43
- Kentucky 38
- Nebraska 38
- Michigan 35
- Puerto Rico 33
- Indiana 32
- New Mexico 31
- Nevada 29
- North Carolina 28
- Arkansas 25
- Ohio 24
- Iowa 23
- Minnesota 23
- Illinois 22
- Mississippi 22
- West Virginia 22
- North Dakota 21
- Oklahoma 21
- Pennsylvania 17
- Tennessee 17
- Washington 17
- California 15
- New York 15
- Idaho 14
- …
country_or_region 1
- US · 1,123 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2018869 | 2018869 | 2022-09-20 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-21 04:23:22 | Eureka, Nevada, US | |
3572742 | 3572742 | 2022-09-19 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-20 04:22:48 | Eureka, Nevada, US | |
421481 | 421481 | 2022-09-18 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-19 04:21:49 | Eureka, Nevada, US | |
3375505 | 3375505 | 2022-09-17 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-18 04:22:50 | Eureka, Nevada, US | |
2357613 | 2357613 | 2022-09-16 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-17 04:20:19 | Eureka, Nevada, US | |
3988770 | 3988770 | 2022-09-15 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-16 04:21:19 | Eureka, Nevada, US | |
1891287 | 1891287 | 2022-09-14 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-15 04:21:02 | Eureka, Nevada, US | |
374342 | 374342 | 2022-09-13 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-14 04:20:44 | Eureka, Nevada, US | |
2396944 | 2396944 | 2022-09-12 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-13 04:20:57 | Eureka, Nevada, US | |
3768022 | 3768022 | 2022-09-11 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-12 04:20:58 | Eureka, Nevada, US | |
3826597 | 3826597 | 2022-09-10 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-11 04:20:50 | Eureka, Nevada, US | |
965054 | 965054 | 2022-09-09 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-10 04:21:10 | Eureka, Nevada, US | |
255456 | 255456 | 2022-09-08 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-09 04:21:11 | Eureka, Nevada, US | |
3747254 | 3747254 | 2022-09-07 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-08 04:21:02 | Eureka, Nevada, US | |
116894 | 116894 | 2022-09-06 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-07 04:20:59 | Eureka, Nevada, US | |
2635866 | 2635866 | 2022-09-05 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-06 04:21:02 | Eureka, Nevada, US | |
2989430 | 2989430 | 2022-09-04 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-05 04:21:01 | Eureka, Nevada, US | |
2715115 | 2715115 | 2022-09-03 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-04 04:21:22 | Eureka, Nevada, US | |
1395820 | 1395820 | 2022-09-02 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-03 04:21:04 | Eureka, Nevada, US | |
3549649 | 3549649 | 2022-09-01 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-02 04:21:07 | Eureka, Nevada, US | |
2345569 | 2345569 | 2022-08-31 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-09-01 04:21:03 | Eureka, Nevada, US | |
3776049 | 3776049 | 2022-08-30 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-31 04:20:57 | Eureka, Nevada, US | |
1682645 | 1682645 | 2022-08-29 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-30 04:21:03 | Eureka, Nevada, US | |
1879129 | 1879129 | 2022-08-28 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-29 04:21:06 | Eureka, Nevada, US | |
2098256 | 2098256 | 2022-08-27 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-28 04:21:02 | Eureka, Nevada, US | |
1534071 | 1534071 | 2022-08-26 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-27 04:20:57 | Eureka, Nevada, US | |
2830958 | 2830958 | 2022-08-25 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-26 04:21:02 | Eureka, Nevada, US | |
2325491 | 2325491 | 2022-08-24 | US | Nevada | Eureka | 32011 | 175 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-08-25 04:21:13 | Eureka, Nevada, US | |
1073067 | 1073067 | 2022-08-07 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-08 04:21:08 | McMullen, Texas, US | |
1943655 | 1943655 | 2022-08-06 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-07 04:20:54 | McMullen, Texas, US | |
883454 | 883454 | 2022-08-05 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-06 04:20:56 | McMullen, Texas, US | |
2011865 | 2011865 | 2022-08-04 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-05 04:20:52 | McMullen, Texas, US | |
1101292 | 1101292 | 2022-08-03 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-04 04:20:58 | McMullen, Texas, US | |
1408217 | 1408217 | 2022-08-02 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-03 04:20:59 | McMullen, Texas, US | |
3620255 | 3620255 | 2022-08-01 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-02 04:20:53 | McMullen, Texas, US | |
3874735 | 3874735 | 2022-07-31 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-01 04:21:03 | McMullen, Texas, US | |
677489 | 677489 | 2022-07-30 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-31 04:21:02 | McMullen, Texas, US | |
1786688 | 1786688 | 2022-07-29 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-30 04:20:42 | McMullen, Texas, US | |
1069051 | 1069051 | 2022-07-28 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-29 04:20:45 | McMullen, Texas, US | |
2338570 | 2338570 | 2022-07-27 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-28 04:20:56 | McMullen, Texas, US | |
1490760 | 1490760 | 2022-07-26 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-27 04:21:04 | McMullen, Texas, US | |
2597206 | 2597206 | 2022-07-25 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-26 04:20:58 | McMullen, Texas, US | |
899321 | 899321 | 2022-07-24 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-25 04:20:51 | McMullen, Texas, US | |
94315 | 94315 | 2022-07-23 | US | Texas | McMullen | 48311 | 175 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-24 04:20:47 | McMullen, Texas, US | |
476071 | 476071 | 2022-06-26 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-27 04:21:00 | Jackson, Colorado, US | |
939446 | 939446 | 2022-06-25 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-26 04:21:02 | Jackson, Colorado, US | |
3347266 | 3347266 | 2022-06-24 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-25 04:20:57 | Jackson, Colorado, US | |
1649007 | 1649007 | 2022-06-23 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-24 04:20:58 | Jackson, Colorado, US | |
2188242 | 2188242 | 2022-06-22 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-23 04:20:55 | Jackson, Colorado, US | |
166673 | 166673 | 2022-06-21 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-22 04:20:54 | Jackson, Colorado, US | |
1763956 | 1763956 | 2022-06-20 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-21 04:20:56 | Jackson, Colorado, US | |
3270142 | 3270142 | 2022-06-19 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-20 04:21:01 | Jackson, Colorado, US | |
3398054 | 3398054 | 2022-06-18 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-19 04:20:51 | Jackson, Colorado, US | |
2311931 | 2311931 | 2022-06-17 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-18 04:21:10 | Jackson, Colorado, US | |
559435 | 559435 | 2022-06-16 | US | Colorado | Jackson | 8057 | 175 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-06-17 04:20:56 | Jackson, Colorado, US | |
232435 | 232435 | 2022-05-31 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-06-01 04:20:55 | Roberts, Texas, US | |
3189200 | 3189200 | 2022-05-30 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-31 04:20:51 | Roberts, Texas, US | |
3201349 | 3201349 | 2022-05-29 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-30 04:20:50 | Roberts, Texas, US | |
2728227 | 2728227 | 2022-05-28 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-29 04:20:53 | Roberts, Texas, US | |
1317408 | 1317408 | 2022-05-27 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-28 04:21:07 | Roberts, Texas, US | |
1853200 | 1853200 | 2022-05-26 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-27 04:20:56 | Roberts, Texas, US | |
2051076 | 2051076 | 2022-05-25 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-26 04:20:50 | Roberts, Texas, US | |
3002514 | 3002514 | 2022-05-24 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-25 04:20:56 | Roberts, Texas, US | |
3596235 | 3596235 | 2022-05-23 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-24 04:20:57 | Roberts, Texas, US | |
625087 | 625087 | 2022-05-22 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-26 04:20:50 | Roberts, Texas, US | |
1112783 | 1112783 | 2022-05-21 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-22 04:20:52 | Roberts, Texas, US | |
1172407 | 1172407 | 2022-05-20 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-21 04:20:58 | Roberts, Texas, US | |
3899170 | 3899170 | 2022-05-19 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-20 04:20:57 | Roberts, Texas, US | |
1187954 | 1187954 | 2022-05-18 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-19 04:20:54 | Roberts, Texas, US | |
3585851 | 3585851 | 2022-05-17 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-18 04:20:50 | Roberts, Texas, US | |
1506808 | 1506808 | 2022-05-16 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-17 04:20:59 | Roberts, Texas, US | |
2087167 | 2087167 | 2022-05-15 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-16 04:20:47 | Roberts, Texas, US | |
3357877 | 3357877 | 2022-05-14 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-15 04:20:53 | Roberts, Texas, US | |
661522 | 661522 | 2022-05-13 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-14 04:20:48 | Roberts, Texas, US | |
2536605 | 2536605 | 2022-05-12 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-13 04:20:51 | Roberts, Texas, US | |
3448051 | 3448051 | 2022-05-11 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-12 04:20:54 | Roberts, Texas, US | |
3538668 | 3538668 | 2022-05-10 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-11 04:20:48 | Roberts, Texas, US | |
225203 | 225203 | 2022-05-09 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-10 04:20:50 | Roberts, Texas, US | |
2334588 | 2334588 | 2022-05-08 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-09 04:20:54 | Roberts, Texas, US | |
363550 | 363550 | 2022-05-07 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-08 04:20:49 | Roberts, Texas, US | |
1400901 | 1400901 | 2022-05-06 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-07 04:21:09 | Roberts, Texas, US | |
2601256 | 2601256 | 2022-05-05 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-06 04:21:00 | Roberts, Texas, US | |
3268705 | 3268705 | 2022-05-04 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-05 04:20:55 | Roberts, Texas, US | |
1575344 | 1575344 | 2022-05-03 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-04 04:20:59 | Roberts, Texas, US | |
466604 | 466604 | 2022-05-02 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-03 04:21:00 | Roberts, Texas, US | |
3919243 | 3919243 | 2022-05-01 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-02 04:21:10 | Roberts, Texas, US | |
2844047 | 2844047 | 2022-04-30 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-01 04:20:57 | Roberts, Texas, US | |
1160360 | 1160360 | 2022-04-29 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-30 04:21:05 | Roberts, Texas, US | |
1699542 | 1699542 | 2022-04-28 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-29 04:20:59 | Roberts, Texas, US | |
3855025 | 3855025 | 2022-04-27 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-28 04:20:47 | Roberts, Texas, US | |
1329455 | 1329455 | 2022-04-26 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-27 04:20:52 | Roberts, Texas, US | |
3725409 | 3725409 | 2022-04-25 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-26 04:20:51 | Roberts, Texas, US | |
2031977 | 2031977 | 2022-04-24 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-25 04:20:56 | Roberts, Texas, US | |
749552 | 749552 | 2022-04-23 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-24 04:20:56 | Roberts, Texas, US | |
3440037 | 3440037 | 2022-04-22 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-23 04:20:50 | Roberts, Texas, US | |
2895622 | 2895622 | 2022-04-21 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-22 04:20:45 | Roberts, Texas, US | |
2310494 | 2310494 | 2022-04-20 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-21 04:20:46 | Roberts, Texas, US | |
2254633 | 2254633 | 2022-04-19 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-20 04:20:45 | Roberts, Texas, US | |
1849183 | 1849183 | 2022-04-18 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-19 04:21:00 | Roberts, Texas, US | |
3420127 | 3420127 | 2022-04-17 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-04-18 04:21:12 | Roberts, 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]);