johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,093 rows where confirmed = 189 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3936182 | 3936182 | 2022-12-09 | New Zealand | Niue | 189 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-10 04:21:02 | Niue, New Zealand | |||
3717381 | 3717381 | 2022-12-06 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-07 04:20:58 | Roberts, Texas, US | |
2418086 | 2418086 | 2022-12-05 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-06 04:21:03 | Roberts, Texas, US | |
721694 | 721694 | 2022-12-04 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-05 04:20:58 | Roberts, Texas, US | |
2819983 | 2819983 | 2022-12-03 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-04 04:20:56 | Roberts, Texas, US | |
836839 | 836839 | 2022-12-02 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-03 04:21:02 | Roberts, Texas, US | |
2139369 | 2139369 | 2022-12-01 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-02 04:21:07 | Roberts, Texas, US | |
1967785 | 1967785 | 2022-11-30 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-01 04:21:03 | Roberts, Texas, US | |
2559799 | 2559799 | 2022-11-29 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-30 04:21:07 | Roberts, Texas, US | |
2559475 | 2559475 | 2022-11-29 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-30 04:21:07 | Jones, South Dakota, US | |
1242873 | 1242873 | 2022-11-28 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-29 04:21:05 | Roberts, Texas, US | |
1242549 | 1242549 | 2022-11-28 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-29 04:21:05 | Jones, South Dakota, US | |
3554861 | 3554861 | 2022-11-27 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-28 04:21:02 | Roberts, Texas, US | |
3554537 | 3554537 | 2022-11-27 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-28 04:21:02 | Jones, South Dakota, US | |
3553769 | 3553769 | 2022-11-27 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-28 04:21:02 | Rock, Nebraska, US | |
2103341 | 2103341 | 2022-11-26 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-27 04:21:05 | Roberts, Texas, US | |
2103017 | 2103017 | 2022-11-26 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-27 04:21:05 | Jones, South Dakota, US | |
2102249 | 2102249 | 2022-11-26 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-27 04:21:05 | Rock, Nebraska, US | |
490832 | 490832 | 2022-11-25 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-26 04:21:11 | Roberts, Texas, US | |
490508 | 490508 | 2022-11-25 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-26 04:21:11 | Jones, South Dakota, US | |
489740 | 489740 | 2022-11-25 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-26 04:21:11 | Rock, Nebraska, US | |
3526661 | 3526661 | 2022-11-24 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-25 04:21:06 | Roberts, Texas, US | |
3526337 | 3526337 | 2022-11-24 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-25 04:21:06 | Jones, South Dakota, US | |
3525569 | 3525569 | 2022-11-24 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-25 04:21:06 | Rock, Nebraska, US | |
3315444 | 3315444 | 2022-11-23 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-24 04:21:09 | Roberts, Texas, US | |
3315120 | 3315120 | 2022-11-23 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-24 04:21:09 | Jones, South Dakota, US | |
3314352 | 3314352 | 2022-11-23 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-24 04:21:09 | Rock, Nebraska, US | |
1623485 | 1623485 | 2022-11-22 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-23 04:21:06 | Roberts, Texas, US | |
1623161 | 1623161 | 2022-11-22 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-23 04:21:06 | Jones, South Dakota, US | |
1622393 | 1622393 | 2022-11-22 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-23 04:21:06 | Rock, Nebraska, US | |
3463373 | 3463373 | 2022-11-21 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-22 04:20:47 | Roberts, Texas, US | |
3463049 | 3463049 | 2022-11-21 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-22 04:20:47 | Jones, South Dakota, US | |
3462281 | 3462281 | 2022-11-21 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-22 04:20:47 | Rock, Nebraska, US | |
1643558 | 1643558 | 2022-11-20 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-21 04:21:05 | Roberts, Texas, US | |
1643234 | 1643234 | 2022-11-20 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-21 04:21:05 | Jones, South Dakota, US | |
1642466 | 1642466 | 2022-11-20 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-21 04:21:05 | Rock, Nebraska, US | |
2067115 | 2067115 | 2022-11-19 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-20 04:21:08 | Roberts, Texas, US | |
2066791 | 2066791 | 2022-11-19 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-20 04:21:08 | Jones, South Dakota, US | |
2066023 | 2066023 | 2022-11-19 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-20 04:21:08 | Rock, Nebraska, US | |
1758509 | 1758509 | 2022-11-18 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-19 04:21:14 | Roberts, Texas, US | |
1758185 | 1758185 | 2022-11-18 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-19 04:21:14 | Jones, South Dakota, US | |
1757417 | 1757417 | 2022-11-18 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-19 04:21:14 | Rock, Nebraska, US | |
3029502 | 3029502 | 2022-11-17 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-18 04:21:15 | Roberts, Texas, US | |
3029178 | 3029178 | 2022-11-17 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-18 04:21:15 | Jones, South Dakota, US | |
3028410 | 3028410 | 2022-11-17 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-18 04:21:15 | Rock, Nebraska, US | |
2489213 | 2489213 | 2022-11-16 | US | Texas | Roberts | 48393 | 189 | 2 | 0 | 35.83809685 | -100.813175 | 2022-11-17 04:21:11 | Roberts, Texas, US | |
2488889 | 2488889 | 2022-11-16 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-17 04:21:11 | Jones, South Dakota, US | |
2488121 | 2488121 | 2022-11-16 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-17 04:21:11 | Rock, Nebraska, US | |
294900 | 294900 | 2022-11-15 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-16 04:21:09 | Jones, South Dakota, US | |
294132 | 294132 | 2022-11-15 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-16 04:21:09 | Rock, Nebraska, US | |
292677 | 292677 | 2022-11-15 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-16 04:21:09 | Unassigned, Colorado, US | |
3599930 | 3599930 | 2022-11-14 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-15 04:21:16 | Jones, South Dakota, US | |
3599162 | 3599162 | 2022-11-14 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-15 04:21:16 | Rock, Nebraska, US | |
3597707 | 3597707 | 2022-11-14 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-15 04:21:16 | Unassigned, Colorado, US | |
314788 | 314788 | 2022-11-13 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-14 04:21:09 | Jones, South Dakota, US | |
314020 | 314020 | 2022-11-13 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-14 04:21:09 | Rock, Nebraska, US | |
312565 | 312565 | 2022-11-13 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-14 04:21:09 | Unassigned, Colorado, US | |
65949 | 65949 | 2022-11-12 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-13 04:21:14 | Jones, South Dakota, US | |
65181 | 65181 | 2022-11-12 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-13 04:21:14 | Rock, Nebraska, US | |
63726 | 63726 | 2022-11-12 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Colorado, US | |
2930111 | 2930111 | 2022-11-11 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-12 04:20:41 | Jones, South Dakota, US | |
2929343 | 2929343 | 2022-11-11 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-12 04:20:41 | Rock, Nebraska, US | |
2927888 | 2927888 | 2022-11-11 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-12 04:20:41 | Unassigned, Colorado, US | |
2508947 | 2508947 | 2022-11-10 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-11 04:21:22 | Jones, South Dakota, US | |
2508179 | 2508179 | 2022-11-10 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-11 04:21:22 | Rock, Nebraska, US | |
2506724 | 2506724 | 2022-11-10 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-11 04:21:22 | Unassigned, Colorado, US | |
2433822 | 2433822 | 2022-11-09 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-10 04:21:16 | Jones, South Dakota, US | |
2433054 | 2433054 | 2022-11-09 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-10 04:21:16 | Rock, Nebraska, US | |
2431599 | 2431599 | 2022-11-09 | US | Colorado | Unassigned | 90008 | 189 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-10 04:21:16 | Unassigned, Colorado, US | |
482478 | 482478 | 2022-11-08 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-09 04:21:22 | Jones, South Dakota, US | |
481710 | 481710 | 2022-11-08 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-09 04:21:22 | Rock, Nebraska, US | |
2441628 | 2441628 | 2022-11-07 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-08 04:21:21 | Jones, South Dakota, US | |
2440860 | 2440860 | 2022-11-07 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-08 04:21:21 | Rock, Nebraska, US | |
1052726 | 1052726 | 2022-11-06 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-07 04:21:26 | Jones, South Dakota, US | |
1051958 | 1051958 | 2022-11-06 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-07 04:21:26 | Rock, Nebraska, US | |
620750 | 620750 | 2022-11-05 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-06 04:21:24 | Jones, South Dakota, US | |
619982 | 619982 | 2022-11-05 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-06 04:21:24 | Rock, Nebraska, US | |
1025254 | 1025254 | 2022-11-04 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-05 04:21:52 | Jones, South Dakota, US | |
1024486 | 1024486 | 2022-11-04 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-05 04:21:52 | Rock, Nebraska, US | |
434245 | 434245 | 2022-11-03 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-04 04:22:11 | Jones, South Dakota, US | |
433477 | 433477 | 2022-11-03 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-04 04:22:11 | Rock, Nebraska, US | |
852487 | 852487 | 2022-11-02 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-03 04:22:05 | Jones, South Dakota, US | |
851719 | 851719 | 2022-11-02 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-03 04:22:05 | Rock, Nebraska, US | |
713338 | 713338 | 2022-11-01 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-02 04:22:09 | Jones, South Dakota, US | |
712570 | 712570 | 2022-11-01 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-02 04:22:09 | Rock, Nebraska, US | |
3287787 | 3287787 | 2022-10-31 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-11-01 04:22:36 | Jones, South Dakota, US | |
3287019 | 3287019 | 2022-10-31 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-01 04:22:36 | Rock, Nebraska, US | |
322820 | 322820 | 2022-10-30 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-10-31 04:21:36 | Jones, South Dakota, US | |
322052 | 322052 | 2022-10-30 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-10-31 04:21:36 | Rock, Nebraska, US | |
915096 | 915096 | 2022-10-29 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-10-30 04:22:14 | Jones, South Dakota, US | |
914328 | 914328 | 2022-10-29 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-10-30 04:22:14 | Rock, Nebraska, US | |
1369365 | 1369365 | 2022-10-28 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-10-29 04:21:13 | Jones, South Dakota, US | |
1368597 | 1368597 | 2022-10-28 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-10-29 04:21:13 | Rock, Nebraska, US | |
3041220 | 3041220 | 2022-10-27 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-10-28 04:22:31 | Jones, South Dakota, US | |
3040452 | 3040452 | 2022-10-27 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-10-28 04:22:31 | Rock, Nebraska, US | |
541640 | 541640 | 2022-10-26 | US | South Dakota | Jones | 46075 | 189 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-10-27 04:22:01 | Jones, South Dakota, US | |
540872 | 540872 | 2022-10-26 | US | Nebraska | Rock | 31149 | 189 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-10-27 04:22:01 | Rock, Nebraska, US | |
3647373 | 3647373 | 2022-08-14 | China | Guizhou | 189 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-15 04:20:59 | Guizhou, China | |||
1968379 | 1968379 | 2022-08-13 | China | Guizhou | 189 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-14 04:20:55 | Guizhou, China | |||
2888188 | 2888188 | 2022-08-12 | China | Guizhou | 189 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-13 04:20:52 | Guizhou, China |
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]);