johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,487 rows where latitude = "41.74228275" and province_or_state = "California" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753453 | 2753453 | 2022-12-29 | US | California | Del Norte | 6015 | 8066 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-30 04:21:04 | Del Norte, California, US | |
2753476 | 2753476 | 2022-12-29 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-30 04:21:04 | Out of CA, California, US | |
2753502 | 2753502 | 2022-12-29 | US | California | Unassigned | 90006 | 4595 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-30 04:21:04 | Unassigned, California, US | |
1074459 | 1074459 | 2022-12-28 | US | California | Del Norte | 6015 | 8066 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-29 04:21:01 | Del Norte, California, US | |
1074482 | 1074482 | 2022-12-28 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-29 04:21:01 | Out of CA, California, US | |
1074508 | 1074508 | 2022-12-28 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-29 04:21:01 | Unassigned, California, US | |
328456 | 328456 | 2022-12-27 | US | California | Del Norte | 6015 | 8066 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-28 04:21:04 | Del Norte, California, US | |
328479 | 328479 | 2022-12-27 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-28 04:21:04 | Out of CA, California, US | |
328505 | 328505 | 2022-12-27 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-28 04:21:04 | Unassigned, California, US | |
218529 | 218529 | 2022-12-26 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-27 04:21:07 | Del Norte, California, US | |
218552 | 218552 | 2022-12-26 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-27 04:21:07 | Out of CA, California, US | |
218578 | 218578 | 2022-12-26 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-27 04:21:07 | Unassigned, California, US | |
3222986 | 3222986 | 2022-12-25 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-26 04:21:06 | Del Norte, California, US | |
3223009 | 3223009 | 2022-12-25 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-26 04:21:06 | Out of CA, California, US | |
3223035 | 3223035 | 2022-12-25 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-26 04:21:06 | Unassigned, California, US | |
1018900 | 1018900 | 2022-12-24 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-25 04:21:04 | Del Norte, California, US | |
1018923 | 1018923 | 2022-12-24 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-25 04:21:04 | Out of CA, California, US | |
1018949 | 1018949 | 2022-12-24 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-25 04:21:04 | Unassigned, California, US | |
690923 | 690923 | 2022-12-23 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-24 04:21:02 | Del Norte, California, US | |
690946 | 690946 | 2022-12-23 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-24 04:21:02 | Out of CA, California, US | |
690972 | 690972 | 2022-12-23 | US | California | Unassigned | 90006 | 4406 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-24 04:21:02 | Unassigned, California, US | |
2180133 | 2180133 | 2022-12-22 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-23 04:21:04 | Del Norte, California, US | |
2180156 | 2180156 | 2022-12-22 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-23 04:21:04 | Out of CA, California, US | |
2180182 | 2180182 | 2022-12-22 | US | California | Unassigned | 90006 | 4396 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-23 04:21:04 | Unassigned, California, US | |
451937 | 451937 | 2022-12-21 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-22 04:20:56 | Del Norte, California, US | |
451960 | 451960 | 2022-12-21 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-22 04:20:56 | Out of CA, California, US | |
451986 | 451986 | 2022-12-21 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-22 04:20:56 | Unassigned, California, US | |
2951936 | 2951936 | 2022-12-20 | US | California | Del Norte | 6015 | 8033 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-21 04:21:03 | Del Norte, California, US | |
2951959 | 2951959 | 2022-12-20 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-21 04:21:03 | Out of CA, California, US | |
2951985 | 2951985 | 2022-12-20 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-21 04:21:03 | Unassigned, California, US | |
3174338 | 3174338 | 2022-12-19 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-20 04:21:04 | Del Norte, California, US | |
3174361 | 3174361 | 2022-12-19 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-20 04:21:04 | Out of CA, California, US | |
3174387 | 3174387 | 2022-12-19 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-20 04:21:04 | Unassigned, California, US | |
1628855 | 1628855 | 2022-12-18 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-19 04:21:03 | Del Norte, California, US | |
1628878 | 1628878 | 2022-12-18 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-19 04:21:03 | Out of CA, California, US | |
1628904 | 1628904 | 2022-12-18 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-19 04:21:03 | Unassigned, California, US | |
504234 | 504234 | 2022-12-17 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-18 04:21:03 | Del Norte, California, US | |
504257 | 504257 | 2022-12-17 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-18 04:21:03 | Out of CA, California, US | |
504283 | 504283 | 2022-12-17 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-18 04:21:03 | Unassigned, California, US | |
3324806 | 3324806 | 2022-12-16 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-17 04:21:04 | Del Norte, California, US | |
3324829 | 3324829 | 2022-12-16 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-17 04:21:04 | Out of CA, California, US | |
3324855 | 3324855 | 2022-12-16 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-17 04:21:04 | Unassigned, California, US | |
543318 | 543318 | 2022-12-15 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-16 04:21:01 | Del Norte, California, US | |
543341 | 543341 | 2022-12-15 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-16 04:21:01 | Out of CA, California, US | |
543367 | 543367 | 2022-12-15 | US | California | Unassigned | 90006 | 4445 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-16 04:21:01 | Unassigned, California, US | |
348846 | 348846 | 2022-12-14 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-15 04:20:58 | Del Norte, California, US | |
348869 | 348869 | 2022-12-14 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-15 04:20:58 | Out of CA, California, US | |
348895 | 348895 | 2022-12-14 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-15 04:20:58 | Unassigned, California, US | |
308434 | 308434 | 2022-12-13 | US | California | Del Norte | 6015 | 8007 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-14 04:21:04 | Del Norte, California, US | |
308457 | 308457 | 2022-12-13 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-14 04:21:04 | Out of CA, California, US | |
308483 | 308483 | 2022-12-13 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-14 04:21:04 | Unassigned, California, US | |
1149495 | 1149495 | 2022-12-12 | US | California | Del Norte | 6015 | 7984 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-13 04:21:01 | Del Norte, California, US | |
1149518 | 1149518 | 2022-12-12 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-13 04:21:01 | Out of CA, California, US | |
1149544 | 1149544 | 2022-12-12 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-13 04:21:01 | Unassigned, California, US | |
869349 | 869349 | 2022-12-11 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-12 04:21:01 | Del Norte, California, US | |
869372 | 869372 | 2022-12-11 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-12 04:21:01 | Out of CA, California, US | |
869398 | 869398 | 2022-12-11 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-12 04:21:01 | Unassigned, California, US | |
257879 | 257879 | 2022-12-10 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-11 04:20:50 | Del Norte, California, US | |
257902 | 257902 | 2022-12-10 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-11 04:20:50 | Out of CA, California, US | |
257928 | 257928 | 2022-12-10 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-11 04:20:50 | Unassigned, California, US | |
3936593 | 3936593 | 2022-12-09 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-10 04:21:02 | Del Norte, California, US | |
3936616 | 3936616 | 2022-12-09 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-10 04:21:02 | Out of CA, California, US | |
3936642 | 3936642 | 2022-12-09 | US | California | Unassigned | 90006 | 4453 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-10 04:21:02 | Unassigned, California, US | |
3377925 | 3377925 | 2022-12-08 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-09 04:21:05 | Del Norte, California, US | |
3377948 | 3377948 | 2022-12-08 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-09 04:21:05 | Out of CA, California, US | |
3377974 | 3377974 | 2022-12-08 | US | California | Unassigned | 90006 | 4399 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-09 04:21:05 | Unassigned, California, US | |
1985196 | 1985196 | 2022-12-07 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-08 04:21:07 | Del Norte, California, US | |
1985219 | 1985219 | 2022-12-07 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-08 04:21:07 | Out of CA, California, US | |
1985245 | 1985245 | 2022-12-07 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-08 04:21:07 | Unassigned, California, US | |
3714719 | 3714719 | 2022-12-06 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-07 04:20:58 | Del Norte, California, US | |
3714742 | 3714742 | 2022-12-06 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-07 04:20:58 | Out of CA, California, US | |
3714768 | 3714768 | 2022-12-06 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-07 04:20:58 | Unassigned, California, US | |
2415424 | 2415424 | 2022-12-05 | US | California | Del Norte | 6015 | 7938 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-06 04:21:03 | Del Norte, California, US | |
2415447 | 2415447 | 2022-12-05 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-06 04:21:03 | Out of CA, California, US | |
2415473 | 2415473 | 2022-12-05 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-06 04:21:03 | Unassigned, California, US | |
719032 | 719032 | 2022-12-04 | US | California | Del Norte | 6015 | 7938 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-05 04:20:58 | Del Norte, California, US | |
719055 | 719055 | 2022-12-04 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-05 04:20:58 | Out of CA, California, US | |
719081 | 719081 | 2022-12-04 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-05 04:20:58 | Unassigned, California, US | |
2817321 | 2817321 | 2022-12-03 | US | California | Del Norte | 6015 | 7937 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-04 04:20:56 | Del Norte, California, US | |
2817344 | 2817344 | 2022-12-03 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-04 04:20:56 | Out of CA, California, US | |
2817370 | 2817370 | 2022-12-03 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-04 04:20:56 | Unassigned, California, US | |
834177 | 834177 | 2022-12-02 | US | California | Del Norte | 6015 | 7937 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-03 04:21:02 | Del Norte, California, US | |
834200 | 834200 | 2022-12-02 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-03 04:21:02 | Out of CA, California, US | |
834226 | 834226 | 2022-12-02 | US | California | Unassigned | 90006 | 4305 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-03 04:21:02 | Unassigned, California, US | |
2136707 | 2136707 | 2022-12-01 | US | California | Del Norte | 6015 | 7937 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-02 04:21:07 | Del Norte, California, US | |
2136730 | 2136730 | 2022-12-01 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-02 04:21:07 | Out of CA, California, US | |
2136756 | 2136756 | 2022-12-01 | US | California | Unassigned | 90006 | 4356 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-02 04:21:07 | Unassigned, California, US | |
1965123 | 1965123 | 2022-11-30 | US | California | Del Norte | 6015 | 7936 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-01 04:21:03 | Del Norte, California, US | |
1965146 | 1965146 | 2022-11-30 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-01 04:21:03 | Out of CA, California, US | |
1965172 | 1965172 | 2022-11-30 | US | California | Unassigned | 90006 | 4402 | 0 | 0 | 41.74228275 | 0.0 | 2022-12-01 04:21:03 | Unassigned, California, US | |
2557137 | 2557137 | 2022-11-29 | US | California | Del Norte | 6015 | 7936 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-11-30 04:21:07 | Del Norte, California, US | |
2557160 | 2557160 | 2022-11-29 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-30 04:21:07 | Out of CA, California, US | |
2557186 | 2557186 | 2022-11-29 | US | California | Unassigned | 90006 | 4402 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-30 04:21:07 | Unassigned, California, US | |
1240211 | 1240211 | 2022-11-28 | US | California | Del Norte | 6015 | 7918 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-11-29 04:21:05 | Del Norte, California, US | |
1240234 | 1240234 | 2022-11-28 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-29 04:21:05 | Out of CA, California, US | |
1240260 | 1240260 | 2022-11-28 | US | California | Unassigned | 90006 | 4402 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-29 04:21:05 | Unassigned, California, US | |
3552199 | 3552199 | 2022-11-27 | US | California | Del Norte | 6015 | 7914 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-11-28 04:21:02 | Del Norte, California, US | |
3552222 | 3552222 | 2022-11-27 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-28 04:21:02 | Out of CA, California, US | |
3552248 | 3552248 | 2022-11-27 | US | California | Unassigned | 90006 | 4402 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-28 04:21:02 | Unassigned, California, US | |
2100679 | 2100679 | 2022-11-26 | US | California | Del Norte | 6015 | 7913 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-11-27 04:21:05 | Del Norte, 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]);