johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Amador, California, US" and province_or_state = "California" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753448 | 2753448 | 2022-12-29 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-30 04:21:04 | Amador, California, US | |
1074454 | 1074454 | 2022-12-28 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-29 04:21:01 | Amador, California, US | |
328451 | 328451 | 2022-12-27 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-28 04:21:04 | Amador, California, US | |
218524 | 218524 | 2022-12-26 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-27 04:21:07 | Amador, California, US | |
3222981 | 3222981 | 2022-12-25 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-26 04:21:06 | Amador, California, US | |
1018895 | 1018895 | 2022-12-24 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-25 04:21:04 | Amador, California, US | |
690918 | 690918 | 2022-12-23 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-24 04:21:02 | Amador, California, US | |
2180128 | 2180128 | 2022-12-22 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-23 04:21:04 | Amador, California, US | |
451932 | 451932 | 2022-12-21 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-22 04:20:56 | Amador, California, US | |
2951931 | 2951931 | 2022-12-20 | US | California | Amador | 6005 | 11225 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-21 04:21:03 | Amador, California, US | |
3174333 | 3174333 | 2022-12-19 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-20 04:21:04 | Amador, California, US | |
1628850 | 1628850 | 2022-12-18 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-19 04:21:03 | Amador, California, US | |
504229 | 504229 | 2022-12-17 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-18 04:21:03 | Amador, California, US | |
3324801 | 3324801 | 2022-12-16 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-17 04:21:04 | Amador, California, US | |
543313 | 543313 | 2022-12-15 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-16 04:21:01 | Amador, California, US | |
348841 | 348841 | 2022-12-14 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-15 04:20:58 | Amador, California, US | |
308429 | 308429 | 2022-12-13 | US | California | Amador | 6005 | 11192 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-14 04:21:04 | Amador, California, US | |
1149490 | 1149490 | 2022-12-12 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-13 04:21:01 | Amador, California, US | |
869344 | 869344 | 2022-12-11 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-12 04:21:01 | Amador, California, US | |
257874 | 257874 | 2022-12-10 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-11 04:20:50 | Amador, California, US | |
3936588 | 3936588 | 2022-12-09 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-10 04:21:02 | Amador, California, US | |
3377920 | 3377920 | 2022-12-08 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-09 04:21:05 | Amador, California, US | |
1985191 | 1985191 | 2022-12-07 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-08 04:21:07 | Amador, California, US | |
3714714 | 3714714 | 2022-12-06 | US | California | Amador | 6005 | 11152 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-07 04:20:58 | Amador, California, US | |
2415419 | 2415419 | 2022-12-05 | US | California | Amador | 6005 | 11106 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-06 04:21:03 | Amador, California, US | |
719027 | 719027 | 2022-12-04 | US | California | Amador | 6005 | 11106 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-05 04:20:58 | Amador, California, US | |
2817316 | 2817316 | 2022-12-03 | US | California | Amador | 6005 | 11106 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-04 04:20:56 | Amador, California, US | |
834172 | 834172 | 2022-12-02 | US | California | Amador | 6005 | 11105 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-03 04:21:02 | Amador, California, US | |
2136702 | 2136702 | 2022-12-01 | US | California | Amador | 6005 | 11105 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-02 04:21:07 | Amador, California, US | |
1965118 | 1965118 | 2022-11-30 | US | California | Amador | 6005 | 11105 | 95 | 0 | 38.44583082 | -120.65696 | 2022-12-01 04:21:03 | Amador, California, US | |
2557132 | 2557132 | 2022-11-29 | US | California | Amador | 6005 | 11105 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-30 04:21:07 | Amador, California, US | |
1240206 | 1240206 | 2022-11-28 | US | California | Amador | 6005 | 11087 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-29 04:21:05 | Amador, California, US | |
3552194 | 3552194 | 2022-11-27 | US | California | Amador | 6005 | 11086 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-28 04:21:02 | Amador, California, US | |
2100674 | 2100674 | 2022-11-26 | US | California | Amador | 6005 | 11084 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-27 04:21:05 | Amador, California, US | |
488165 | 488165 | 2022-11-25 | US | California | Amador | 6005 | 11083 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-26 04:21:11 | Amador, California, US | |
3523994 | 3523994 | 2022-11-24 | US | California | Amador | 6005 | 11083 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-25 04:21:06 | Amador, California, US | |
3312777 | 3312777 | 2022-11-23 | US | California | Amador | 6005 | 11083 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-24 04:21:09 | Amador, California, US | |
1620818 | 1620818 | 2022-11-22 | US | California | Amador | 6005 | 11082 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-23 04:21:06 | Amador, California, US | |
3460706 | 3460706 | 2022-11-21 | US | California | Amador | 6005 | 11057 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-22 04:20:47 | Amador, California, US | |
1640891 | 1640891 | 2022-11-20 | US | California | Amador | 6005 | 11055 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-21 04:21:05 | Amador, California, US | |
2064448 | 2064448 | 2022-11-19 | US | California | Amador | 6005 | 11055 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-20 04:21:08 | Amador, California, US | |
1755842 | 1755842 | 2022-11-18 | US | California | Amador | 6005 | 11055 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-19 04:21:14 | Amador, California, US | |
3026835 | 3026835 | 2022-11-17 | US | California | Amador | 6005 | 11054 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-18 04:21:15 | Amador, California, US | |
2486546 | 2486546 | 2022-11-16 | US | California | Amador | 6005 | 11054 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-17 04:21:11 | Amador, California, US | |
292557 | 292557 | 2022-11-15 | US | California | Amador | 6005 | 11052 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-16 04:21:09 | Amador, California, US | |
3597587 | 3597587 | 2022-11-14 | US | California | Amador | 6005 | 11024 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-15 04:21:16 | Amador, California, US | |
312445 | 312445 | 2022-11-13 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-14 04:21:09 | Amador, California, US | |
63606 | 63606 | 2022-11-12 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-13 04:21:14 | Amador, California, US | |
2927768 | 2927768 | 2022-11-11 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-12 04:20:41 | Amador, California, US | |
2506604 | 2506604 | 2022-11-10 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-11 04:21:22 | Amador, California, US | |
2431479 | 2431479 | 2022-11-09 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-10 04:21:16 | Amador, California, US | |
480135 | 480135 | 2022-11-08 | US | California | Amador | 6005 | 11023 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-09 04:21:22 | Amador, California, US | |
2439285 | 2439285 | 2022-11-07 | US | California | Amador | 6005 | 10997 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-08 04:21:21 | Amador, California, US | |
1050383 | 1050383 | 2022-11-06 | US | California | Amador | 6005 | 10996 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-07 04:21:26 | Amador, California, US | |
618407 | 618407 | 2022-11-05 | US | California | Amador | 6005 | 10996 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-06 04:21:24 | Amador, California, US | |
1022911 | 1022911 | 2022-11-04 | US | California | Amador | 6005 | 10996 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-05 04:21:52 | Amador, California, US | |
431902 | 431902 | 2022-11-03 | US | California | Amador | 6005 | 10994 | 95 | 0 | 38.44583082 | -120.65696 | 2022-11-04 04:22:11 | Amador, California, US | |
850144 | 850144 | 2022-11-02 | US | California | Amador | 6005 | 10992 | 94 | 0 | 38.44583082 | -120.65696 | 2022-11-03 04:22:05 | Amador, California, US | |
710995 | 710995 | 2022-11-01 | US | California | Amador | 6005 | 10991 | 94 | 0 | 38.44583082 | -120.65696 | 2022-11-02 04:22:09 | Amador, California, US | |
3285444 | 3285444 | 2022-10-31 | US | California | Amador | 6005 | 10974 | 94 | 0 | 38.44583082 | -120.65696 | 2022-11-01 04:22:36 | Amador, California, US | |
320477 | 320477 | 2022-10-30 | US | California | Amador | 6005 | 10973 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-31 04:21:36 | Amador, California, US | |
912753 | 912753 | 2022-10-29 | US | California | Amador | 6005 | 10973 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-30 04:22:14 | Amador, California, US | |
1367022 | 1367022 | 2022-10-28 | US | California | Amador | 6005 | 10972 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-29 04:21:13 | Amador, California, US | |
3038877 | 3038877 | 2022-10-27 | US | California | Amador | 6005 | 10972 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-28 04:22:31 | Amador, California, US | |
539297 | 539297 | 2022-10-26 | US | California | Amador | 6005 | 10972 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-27 04:22:01 | Amador, California, US | |
1830698 | 1830698 | 2022-10-25 | US | California | Amador | 6005 | 10972 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-26 04:22:19 | Amador, California, US | |
794959 | 794959 | 2022-10-24 | US | California | Amador | 6005 | 10958 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-25 04:21:53 | Amador, California, US | |
3277414 | 3277414 | 2022-10-23 | US | California | Amador | 6005 | 10958 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-24 04:22:29 | Amador, California, US | |
2268452 | 2268452 | 2022-10-22 | US | California | Amador | 6005 | 10958 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-23 04:22:46 | Amador, California, US | |
1592752 | 1592752 | 2022-10-21 | US | California | Amador | 6005 | 10958 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-22 04:22:53 | Amador, California, US | |
2272468 | 2272468 | 2022-10-20 | US | California | Amador | 6005 | 10958 | 94 | 0 | 38.44583082 | -120.65696 | 2022-10-21 04:22:23 | Amador, California, US | |
198803 | 198803 | 2022-10-19 | US | California | Amador | 6005 | 10957 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-20 04:22:59 | Amador, California, US | |
2757464 | 2757464 | 2022-10-18 | US | California | Amador | 6005 | 10955 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-19 04:22:26 | Amador, California, US | |
2025298 | 2025298 | 2022-10-17 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-18 04:22:42 | Amador, California, US | |
2160076 | 2160076 | 2022-10-16 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-17 04:20:31 | Amador, California, US | |
516273 | 516273 | 2022-10-15 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-16 04:22:39 | Amador, California, US | |
2033330 | 2033330 | 2022-10-14 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-15 04:22:00 | Amador, California, US | |
3754018 | 3754018 | 2022-10-13 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-14 04:22:28 | Amador, California, US | |
3214843 | 3214843 | 2022-10-12 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-13 04:22:39 | Amador, California, US | |
3250692 | 3250692 | 2022-10-11 | US | California | Amador | 6005 | 10943 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-12 04:22:51 | Amador, California, US | |
2967951 | 2967951 | 2022-10-10 | US | California | Amador | 6005 | 10929 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-11 04:23:05 | Amador, California, US | |
3097987 | 3097987 | 2022-10-09 | US | California | Amador | 6005 | 10929 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-10 04:22:32 | Amador, California, US | |
4003212 | 4003212 | 2022-10-08 | US | California | Amador | 6005 | 10928 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-09 04:21:16 | Amador, California, US | |
396809 | 396809 | 2022-10-07 | US | California | Amador | 6005 | 10928 | 93 | 0 | 38.44583082 | -120.65696 | 2022-10-08 04:22:56 | Amador, California, US | |
2529926 | 2529926 | 2022-10-06 | US | California | Amador | 6005 | 10928 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-07 04:23:08 | Amador, California, US | |
1811320 | 1811320 | 2022-10-05 | US | California | Amador | 6005 | 10928 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-06 04:21:22 | Amador, California, US | |
131294 | 131294 | 2022-10-04 | US | California | Amador | 6005 | 10928 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-05 04:23:06 | Amador, California, US | |
2686241 | 2686241 | 2022-10-03 | US | California | Amador | 6005 | 10916 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-04 04:22:55 | Amador, California, US | |
2260308 | 2260308 | 2022-10-02 | US | California | Amador | 6005 | 10916 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-03 04:23:11 | Amador, California, US | |
2995834 | 2995834 | 2022-10-01 | US | California | Amador | 6005 | 10916 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-02 04:21:23 | Amador, California, US | |
854160 | 854160 | 2022-09-30 | US | California | Amador | 6005 | 10916 | 90 | 0 | 38.44583082 | -120.65696 | 2022-10-01 04:23:01 | Amador, California, US | |
2376086 | 2376086 | 2022-09-29 | US | California | Amador | 6005 | 10915 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-30 04:23:09 | Amador, California, US | |
1560637 | 1560637 | 2022-09-28 | US | California | Amador | 6005 | 10915 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-29 04:22:34 | Amador, California, US | |
3995180 | 3995180 | 2022-09-27 | US | California | Amador | 6005 | 10913 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-28 04:23:01 | Amador, California, US | |
2769508 | 2769508 | 2022-09-26 | US | California | Amador | 6005 | 10879 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-27 04:23:01 | Amador, California, US | |
1977161 | 1977161 | 2022-09-25 | US | California | Amador | 6005 | 10877 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-26 04:20:52 | Amador, California, US | |
2650328 | 2650328 | 2022-09-24 | US | California | Amador | 6005 | 10876 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-25 04:23:31 | Amador, California, US | |
384768 | 384768 | 2022-09-23 | US | California | Amador | 6005 | 10876 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-24 04:21:40 | Amador, California, US | |
1624834 | 1624834 | 2022-09-22 | US | California | Amador | 6005 | 10876 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-23 04:23:13 | Amador, California, US | |
1371038 | 1371038 | 2022-09-21 | US | California | Amador | 6005 | 10876 | 90 | 0 | 38.44583082 | -120.65696 | 2022-09-22 04:22:56 | Amador, California, 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]);