johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
511 rows where confirmed = 1093 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309187 | 309187 | 2022-12-13 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-14 04:21:04 | Haskell, Kansas, US | |
1150248 | 1150248 | 2022-12-12 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-13 04:21:01 | Haskell, Kansas, US | |
870102 | 870102 | 2022-12-11 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-12 04:21:01 | Haskell, Kansas, US | |
258632 | 258632 | 2022-12-10 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-11 04:20:50 | Haskell, Kansas, US | |
3937346 | 3937346 | 2022-12-09 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-10 04:21:02 | Haskell, Kansas, US | |
3378678 | 3378678 | 2022-12-08 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-09 04:21:05 | Haskell, Kansas, US | |
1985949 | 1985949 | 2022-12-07 | US | Kansas | Haskell | 20081 | 1093 | 14 | 0 | 37.5620394 | -100.8710738 | 2022-12-08 04:21:07 | Haskell, Kansas, US | |
795095 | 795095 | 2022-10-24 | US | Delaware | Unassigned | 90010 | 1093 | 0 | 0 | 39.57992638 | 0.0 | 2022-10-25 04:21:53 | Unassigned, Delaware, US | |
3099847 | 3099847 | 2022-10-09 | US | North Dakota | Foster | 38031 | 1093 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-10-10 04:22:32 | Foster, North Dakota, US | |
4005072 | 4005072 | 2022-10-08 | US | North Dakota | Foster | 38031 | 1093 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-10-09 04:21:16 | Foster, North Dakota, US | |
398669 | 398669 | 2022-10-07 | US | North Dakota | Foster | 38031 | 1093 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-10-08 04:22:56 | Foster, North Dakota, US | |
2687547 | 2687547 | 2022-10-03 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-10-04 04:22:55 | Sharkey, Mississippi, US | |
2261614 | 2261614 | 2022-10-02 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-10-03 04:23:11 | Sharkey, Mississippi, US | |
2997140 | 2997140 | 2022-10-01 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-10-02 04:21:23 | Sharkey, Mississippi, US | |
855466 | 855466 | 2022-09-30 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-10-01 04:23:01 | Sharkey, Mississippi, US | |
2377392 | 2377392 | 2022-09-29 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-09-30 04:23:09 | Sharkey, Mississippi, US | |
1561943 | 1561943 | 2022-09-28 | US | Mississippi | Sharkey | 28125 | 1093 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-09-29 04:22:34 | Sharkey, Mississippi, US | |
422539 | 422539 | 2022-09-18 | US | Texas | Presidio | 48377 | 1093 | 40 | 0 | 29.99954402 | -104.2408079 | 2022-09-19 04:21:49 | Presidio, Texas, US | |
3376563 | 3376563 | 2022-09-17 | US | Texas | Presidio | 48377 | 1093 | 40 | 0 | 29.99954402 | -104.2408079 | 2022-09-18 04:22:50 | Presidio, Texas, US | |
2358671 | 2358671 | 2022-09-16 | US | Texas | Presidio | 48377 | 1093 | 40 | 0 | 29.99954402 | -104.2408079 | 2022-09-17 04:20:19 | Presidio, Texas, US | |
1534337 | 1534337 | 2022-08-26 | US | North Dakota | LaMoure | 38045 | 1093 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-08-27 04:20:57 | LaMoure, North Dakota, US | |
2853900 | 2853900 | 2022-08-22 | US | Illinois | Pope | 17151 | 1093 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-08-23 04:20:56 | Pope, Illinois, US | |
1163189 | 1163189 | 2022-08-18 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-19 04:20:54 | Phillips, Montana, US | |
3952513 | 3952513 | 2022-08-17 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-18 04:21:11 | Phillips, Montana, US | |
993015 | 993015 | 2022-08-16 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-17 04:20:59 | Phillips, Montana, US | |
2496054 | 2496054 | 2022-08-15 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-16 04:20:58 | Phillips, Montana, US | |
3649604 | 3649604 | 2022-08-14 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-15 04:20:59 | Phillips, Montana, US | |
1970610 | 1970610 | 2022-08-13 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-14 04:20:55 | Phillips, Montana, US | |
2890419 | 2890419 | 2022-08-12 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-13 04:20:52 | Phillips, Montana, US | |
3910024 | 3910024 | 2022-08-11 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-12 04:20:54 | Phillips, Montana, US | |
1348341 | 1348341 | 2022-08-10 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-11 04:20:49 | Phillips, Montana, US | |
1088942 | 1088942 | 2022-08-09 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-10 04:20:57 | Deuel, South Dakota, US | |
1088514 | 1088514 | 2022-08-09 | US | North Dakota | Wells | 38103 | 1093 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-08-10 04:20:57 | Wells, North Dakota, US | |
1088096 | 1088096 | 2022-08-09 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-10 04:20:57 | Phillips, Montana, US | |
3546357 | 3546357 | 2022-08-08 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-09 04:20:34 | Deuel, South Dakota, US | |
3545511 | 3545511 | 2022-08-08 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-09 04:20:34 | Phillips, Montana, US | |
1072760 | 1072760 | 2022-08-07 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-08 04:21:08 | Deuel, South Dakota, US | |
1071914 | 1071914 | 2022-08-07 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-08 04:21:08 | Phillips, Montana, US | |
1943348 | 1943348 | 2022-08-06 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-07 04:20:54 | Deuel, South Dakota, US | |
1942502 | 1942502 | 2022-08-06 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-07 04:20:54 | Phillips, Montana, US | |
883147 | 883147 | 2022-08-05 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-06 04:20:56 | Deuel, South Dakota, US | |
882301 | 882301 | 2022-08-05 | US | Montana | Phillips | 30071 | 1093 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-08-06 04:20:56 | Phillips, Montana, US | |
2011558 | 2011558 | 2022-08-04 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-05 04:20:52 | Deuel, South Dakota, US | |
1100985 | 1100985 | 2022-08-03 | US | South Dakota | Deuel | 46039 | 1093 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-08-04 04:20:58 | Deuel, South Dakota, US | |
672726 | 672726 | 2022-07-21 | US | North Dakota | Sargent | 38081 | 1093 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-07-22 04:21:15 | Sargent, North Dakota, US | |
1611389 | 1611389 | 2022-07-20 | US | Texas | Hudspeth | 48229 | 1093 | 18 | 0 | 31.45628381 | -105.388178 | 2022-07-21 04:21:10 | Hudspeth, Texas, US | |
1610661 | 1610661 | 2022-07-20 | US | North Dakota | Dunn | 38025 | 1093 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-07-21 04:21:10 | Dunn, North Dakota, US | |
961294 | 961294 | 2022-07-19 | US | North Dakota | Dunn | 38025 | 1093 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-07-20 04:20:59 | Dunn, North Dakota, US | |
630472 | 630472 | 2022-07-12 | US | California | Modoc | 6049 | 1093 | 9 | 0 | 41.58965602 | -120.7244817 | 2022-07-13 04:20:58 | Modoc, California, US | |
594321 | 594321 | 2022-07-01 | US | Colorado | Washington | 8121 | 1093 | 29 | 0 | 39.97015535 | -103.202587 | 2022-07-02 04:21:16 | Washington, Colorado, US | |
3272914 | 3272914 | 2022-06-19 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-20 04:21:01 | Rappahannock, Virginia, US | |
3271561 | 3271561 | 2022-06-19 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-20 04:21:01 | Boone, Nebraska, US | |
3400826 | 3400826 | 2022-06-18 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-19 04:20:51 | Rappahannock, Virginia, US | |
3399473 | 3399473 | 2022-06-18 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-19 04:20:51 | Boone, Nebraska, US | |
2314703 | 2314703 | 2022-06-17 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-18 04:21:10 | Rappahannock, Virginia, US | |
2313350 | 2313350 | 2022-06-17 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-18 04:21:10 | Boone, Nebraska, US | |
562207 | 562207 | 2022-06-16 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-17 04:20:56 | Rappahannock, Virginia, US | |
560854 | 560854 | 2022-06-16 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-17 04:20:56 | Boone, Nebraska, US | |
3986009 | 3986009 | 2022-06-15 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-16 04:20:55 | Rappahannock, Virginia, US | |
3984656 | 3984656 | 2022-06-15 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-16 04:20:55 | Boone, Nebraska, US | |
950250 | 950250 | 2022-06-14 | US | Virginia | Rappahannock | 51157 | 1093 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-06-15 04:20:54 | Rappahannock, Virginia, US | |
949914 | 949914 | 2022-06-14 | US | Texas | Crockett | 48105 | 1093 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-15 04:20:54 | Crockett, Texas, US | |
948897 | 948897 | 2022-06-14 | US | Nebraska | Boone | 31011 | 1093 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-15 04:20:54 | Boone, Nebraska, US | |
2982322 | 2982322 | 2022-06-13 | US | Texas | Crockett | 48105 | 1093 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-14 04:20:52 | Crockett, Texas, US | |
2238448 | 2238448 | 2022-06-12 | US | Texas | Crockett | 48105 | 1093 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-13 04:21:14 | Crockett, Texas, US | |
3144646 | 3144646 | 2022-06-11 | US | Texas | Crockett | 48105 | 1093 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-12 04:20:53 | Crockett, Texas, US | |
1947562 | 1947562 | 2022-06-10 | US | Texas | Crockett | 48105 | 1093 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-11 04:21:01 | Crockett, Texas, US | |
1424318 | 1424318 | 2022-06-08 | US | Texas | San Augustine | 48405 | 1093 | 44 | 0 | 31.39457611 | -94.17000399 | 2022-06-09 04:20:54 | San Augustine, Texas, US | |
3581660 | 3581660 | 2022-06-02 | US | Texas | Brewster | 48043 | 1093 | 30 | 0 | 29.81008251 | -103.2520326 | 2022-06-03 04:20:58 | Brewster, Texas, US | |
232286 | 232286 | 2022-05-31 | US | Texas | Concho | 48095 | 1093 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-06-01 04:20:55 | Concho, Texas, US | |
3189051 | 3189051 | 2022-05-30 | US | Texas | Concho | 48095 | 1093 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-31 04:20:51 | Concho, Texas, US | |
3201200 | 3201200 | 2022-05-29 | US | Texas | Concho | 48095 | 1093 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-30 04:20:50 | Concho, Texas, US | |
2728078 | 2728078 | 2022-05-28 | US | Texas | Concho | 48095 | 1093 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-29 04:20:53 | Concho, Texas, US | |
1317259 | 1317259 | 2022-05-27 | US | Texas | Concho | 48095 | 1093 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-28 04:21:07 | Concho, Texas, US | |
3586188 | 3586188 | 2022-05-17 | US | Wisconsin | Florence | 55037 | 1093 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-05-18 04:20:50 | Florence, Wisconsin, US | |
1507145 | 1507145 | 2022-05-16 | US | Wisconsin | Florence | 55037 | 1093 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-05-17 04:20:59 | Florence, Wisconsin, US | |
2087504 | 2087504 | 2022-05-15 | US | Wisconsin | Florence | 55037 | 1093 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-05-16 04:20:47 | Florence, Wisconsin, US | |
3358214 | 3358214 | 2022-05-14 | US | Wisconsin | Florence | 55037 | 1093 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-05-15 04:20:53 | Florence, Wisconsin, US | |
661859 | 661859 | 2022-05-13 | US | Wisconsin | Florence | 55037 | 1093 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-05-14 04:20:48 | Florence, Wisconsin, US | |
2534321 | 2534321 | 2022-05-12 | US | Idaho | Boise | 16015 | 1093 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-05-13 04:20:51 | Boise, Idaho, US | |
3445767 | 3445767 | 2022-05-11 | US | Idaho | Boise | 16015 | 1093 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-05-12 04:20:54 | Boise, Idaho, US | |
3536384 | 3536384 | 2022-05-10 | US | Idaho | Boise | 16015 | 1093 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-05-11 04:20:48 | Boise, Idaho, US | |
222919 | 222919 | 2022-05-09 | US | Idaho | Boise | 16015 | 1093 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-05-10 04:20:50 | Boise, Idaho, US | |
2032186 | 2032186 | 2022-04-24 | US | Virginia | Surry | 51181 | 1093 | 19 | 0 | 37.11781893 | -76.88450012 | 2022-04-25 04:20:56 | Surry, Virginia, US | |
749761 | 749761 | 2022-04-23 | US | Virginia | Surry | 51181 | 1093 | 19 | 0 | 37.11781893 | -76.88450012 | 2022-04-24 04:20:56 | Surry, Virginia, US | |
3440246 | 3440246 | 2022-04-22 | US | Virginia | Surry | 51181 | 1093 | 19 | 0 | 37.11781893 | -76.88450012 | 2022-04-23 04:20:50 | Surry, Virginia, US | |
1847990 | 1847990 | 2022-04-18 | US | Montana | Mineral | 30061 | 1093 | 17 | 0 | 47.15283992 | -115.00152390000001 | 2022-04-19 04:21:00 | Mineral, Montana, US | |
3418934 | 3418934 | 2022-04-17 | US | Montana | Mineral | 30061 | 1093 | 17 | 0 | 47.15283992 | -115.00152390000001 | 2022-04-18 04:21:12 | Mineral, Montana, US | |
305883 | 305883 | 2022-04-16 | US | Montana | Mineral | 30061 | 1093 | 17 | 0 | 47.15283992 | -115.00152390000001 | 2022-04-17 04:20:59 | Mineral, Montana, US | |
2671828 | 2671828 | 2022-04-15 | US | Montana | Mineral | 30061 | 1093 | 17 | 0 | 47.15283992 | -115.00152390000001 | 2022-04-16 04:20:48 | Mineral, Montana, US | |
2803883 | 2803883 | 2022-04-06 | US | Texas | Hall | 48191 | 1093 | 23 | 0 | 34.5307555 | -100.68138520000001 | 2022-04-07 04:20:53 | Hall, Texas, US | |
3870652 | 3870652 | 2022-04-05 | US | Texas | Hall | 48191 | 1093 | 23 | 0 | 34.5307555 | -100.68138520000001 | 2022-04-06 04:20:49 | Hall, Texas, US | |
695337 | 695337 | 2022-03-17 | US | Idaho | Lincoln | 16063 | 1093 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-03-18 04:20:55 | Lincoln, Idaho, US | |
2320280 | 2320280 | 2022-03-16 | US | Idaho | Lincoln | 16063 | 1093 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-03-17 04:20:56 | Lincoln, Idaho, US | |
2527562 | 2527562 | 2022-03-02 | US | New Mexico | Guadalupe | 35019 | 1093 | 17 | 0 | 34.86319296 | -104.790669 | 2022-03-03 04:21:01 | Guadalupe, New Mexico, US | |
1514693 | 1514693 | 2022-02-24 | US | Vermont | Essex | 50009 | 1093 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-02-25 04:21:11 | Essex, Vermont, US | |
2447935 | 2447935 | 2022-02-22 | US | Iowa | Audubon | 19009 | 1093 | 18 | 0 | 41.6844628 | -94.90581859 | 2022-02-23 04:21:09 | Audubon, Iowa, US | |
3719348 | 3719348 | 2022-02-21 | US | Iowa | Audubon | 19009 | 1093 | 18 | 0 | 41.6844628 | -94.90581859 | 2022-02-22 04:21:01 | Audubon, Iowa, US | |
3913182 | 3913182 | 2022-02-20 | US | Iowa | Audubon | 19009 | 1093 | 18 | 0 | 41.6844628 | -94.90581859 | 2022-02-21 04:21:05 | Audubon, Iowa, US | |
3876740 | 3876740 | 2022-02-19 | US | Iowa | Audubon | 19009 | 1093 | 18 | 0 | 41.6844628 | -94.90581859 | 2022-02-20 04:21:00 | Audubon, Iowa, 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]);