johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Lambayeque" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016894 | 2016894 | 2022-09-20 | Peru | Lambayeque | 119648 | 9329 | 0 | -6.353049 | -79.824113 | 2022-09-21 04:23:22 | Lambayeque, Peru | |||
3570767 | 3570767 | 2022-09-19 | Peru | Lambayeque | 119648 | 9329 | 0 | -6.353049 | -79.824113 | 2022-09-20 04:22:48 | Lambayeque, Peru | |||
419506 | 419506 | 2022-09-18 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-19 04:21:49 | Lambayeque, Peru | |||
3373530 | 3373530 | 2022-09-17 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-18 04:22:50 | Lambayeque, Peru | |||
2355638 | 2355638 | 2022-09-16 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-17 04:20:19 | Lambayeque, Peru | |||
3986795 | 3986795 | 2022-09-15 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-16 04:21:19 | Lambayeque, Peru | |||
1889312 | 1889312 | 2022-09-14 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-15 04:21:02 | Lambayeque, Peru | |||
372367 | 372367 | 2022-09-13 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-14 04:20:44 | Lambayeque, Peru | |||
2394970 | 2394970 | 2022-09-12 | Peru | Lambayeque | 119506 | 9323 | 0 | -6.353049 | -79.824113 | 2022-09-13 04:20:57 | Lambayeque, Peru | |||
3766048 | 3766048 | 2022-09-11 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-12 04:20:58 | Lambayeque, Peru | |||
3824623 | 3824623 | 2022-09-10 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-11 04:20:50 | Lambayeque, Peru | |||
963080 | 963080 | 2022-09-09 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-10 04:21:10 | Lambayeque, Peru | |||
253482 | 253482 | 2022-09-08 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-09 04:21:11 | Lambayeque, Peru | |||
3745280 | 3745280 | 2022-09-07 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-08 04:21:02 | Lambayeque, Peru | |||
114920 | 114920 | 2022-09-06 | Peru | Lambayeque | 119208 | 9317 | 0 | -6.353049 | -79.824113 | 2022-09-07 04:20:59 | Lambayeque, Peru | |||
2633892 | 2633892 | 2022-09-05 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-06 04:21:02 | Lambayeque, Peru | |||
2987456 | 2987456 | 2022-09-04 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-05 04:21:01 | Lambayeque, Peru | |||
2713141 | 2713141 | 2022-09-03 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-04 04:21:22 | Lambayeque, Peru | |||
1393846 | 1393846 | 2022-09-02 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-03 04:21:04 | Lambayeque, Peru | |||
3547675 | 3547675 | 2022-09-01 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-02 04:21:07 | Lambayeque, Peru | |||
2343595 | 2343595 | 2022-08-31 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-09-01 04:21:03 | Lambayeque, Peru | |||
3774075 | 3774075 | 2022-08-30 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-08-31 04:20:57 | Lambayeque, Peru | |||
1680671 | 1680671 | 2022-08-29 | Peru | Lambayeque | 118705 | 9304 | 0 | -6.353049 | -79.824113 | 2022-08-30 04:21:03 | Lambayeque, Peru | |||
1877155 | 1877155 | 2022-08-28 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-29 04:21:06 | Lambayeque, Peru | |||
2096282 | 2096282 | 2022-08-27 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-28 04:21:02 | Lambayeque, Peru | |||
1532097 | 1532097 | 2022-08-26 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-27 04:20:57 | Lambayeque, Peru | |||
2828984 | 2828984 | 2022-08-25 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-26 04:21:02 | Lambayeque, Peru | |||
2323517 | 2323517 | 2022-08-24 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-25 04:21:13 | Lambayeque, Peru | |||
1250926 | 1250926 | 2022-08-23 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-24 04:20:46 | Lambayeque, Peru | |||
2853030 | 2853030 | 2022-08-22 | Peru | Lambayeque | 117883 | 9300 | 0 | -6.353049 | -79.824113 | 2022-08-23 04:20:56 | Lambayeque, Peru | |||
2403002 | 2403002 | 2022-08-21 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-22 04:20:38 | Lambayeque, Peru | |||
3798080 | 3798080 | 2022-08-20 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-21 04:20:44 | Lambayeque, Peru | |||
2363666 | 2363666 | 2022-08-19 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-20 04:21:01 | Lambayeque, Peru | |||
1161337 | 1161337 | 2022-08-18 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-19 04:20:54 | Lambayeque, Peru | |||
3950661 | 3950661 | 2022-08-17 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-18 04:21:11 | Lambayeque, Peru | |||
991163 | 991163 | 2022-08-16 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-17 04:20:59 | Lambayeque, Peru | |||
2494202 | 2494202 | 2022-08-15 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-16 04:20:58 | Lambayeque, Peru | |||
3647752 | 3647752 | 2022-08-14 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-15 04:20:59 | Lambayeque, Peru | |||
1968758 | 1968758 | 2022-08-13 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-14 04:20:55 | Lambayeque, Peru | |||
2888567 | 2888567 | 2022-08-12 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-13 04:20:52 | Lambayeque, Peru | |||
3908172 | 3908172 | 2022-08-11 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-12 04:20:54 | Lambayeque, Peru | |||
1346489 | 1346489 | 2022-08-10 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-11 04:20:49 | Lambayeque, Peru | |||
1086244 | 1086244 | 2022-08-09 | Peru | Lambayeque | 114280 | 9281 | 0 | -6.353049 | -79.824113 | 2022-08-10 04:20:57 | Lambayeque, Peru | |||
3543659 | 3543659 | 2022-08-08 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-09 04:20:34 | Lambayeque, Peru | |||
1070062 | 1070062 | 2022-08-07 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-08 04:21:08 | Lambayeque, Peru | |||
1940650 | 1940650 | 2022-08-06 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-07 04:20:54 | Lambayeque, Peru | |||
880449 | 880449 | 2022-08-05 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-06 04:20:56 | Lambayeque, Peru | |||
2008860 | 2008860 | 2022-08-04 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-05 04:20:52 | Lambayeque, Peru | |||
1098287 | 1098287 | 2022-08-03 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-04 04:20:58 | Lambayeque, Peru | |||
1405212 | 1405212 | 2022-08-02 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-03 04:20:59 | Lambayeque, Peru | |||
3617250 | 3617250 | 2022-08-01 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-02 04:20:53 | Lambayeque, Peru | |||
3871730 | 3871730 | 2022-07-31 | Peru | Lambayeque | 112634 | 9271 | 0 | -6.353049 | -79.824113 | 2022-08-01 04:21:03 | Lambayeque, Peru | |||
674484 | 674484 | 2022-07-30 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-31 04:21:02 | Lambayeque, Peru | |||
1783683 | 1783683 | 2022-07-29 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-30 04:20:42 | Lambayeque, Peru | |||
1066046 | 1066046 | 2022-07-28 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-29 04:20:45 | Lambayeque, Peru | |||
2335565 | 2335565 | 2022-07-27 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-28 04:20:56 | Lambayeque, Peru | |||
1487755 | 1487755 | 2022-07-26 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-27 04:21:04 | Lambayeque, Peru | |||
2594201 | 2594201 | 2022-07-25 | Peru | Lambayeque | 110840 | 9262 | 0 | -6.353049 | -79.824113 | 2022-07-26 04:20:58 | Lambayeque, Peru | |||
896316 | 896316 | 2022-07-24 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-25 04:20:51 | Lambayeque, Peru | |||
91310 | 91310 | 2022-07-23 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-24 04:20:47 | Lambayeque, Peru | |||
900332 | 900332 | 2022-07-22 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-23 04:20:53 | Lambayeque, Peru | |||
670468 | 670468 | 2022-07-21 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-22 04:21:15 | Lambayeque, Peru | |||
1608431 | 1608431 | 2022-07-20 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-21 04:21:10 | Lambayeque, Peru | |||
959064 | 959064 | 2022-07-19 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-20 04:20:59 | Lambayeque, Peru | |||
3210451 | 3210451 | 2022-07-18 | Peru | Lambayeque | 108637 | 9258 | 0 | -6.353049 | -79.824113 | 2022-07-19 04:20:58 | Lambayeque, Peru | |||
3405626 | 3405626 | 2022-07-17 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-18 04:20:59 | Lambayeque, Peru | |||
2151826 | 2151826 | 2022-07-16 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-17 04:21:15 | Lambayeque, Peru | |||
2419059 | 2419059 | 2022-07-15 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-16 04:21:05 | Lambayeque, Peru | |||
3429134 | 3429134 | 2022-07-14 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-15 04:20:53 | Lambayeque, Peru | |||
3109654 | 3109654 | 2022-07-13 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-14 04:20:57 | Lambayeque, Peru | |||
630077 | 630077 | 2022-07-12 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-13 04:20:58 | Lambayeque, Peru | |||
1211721 | 1211721 | 2022-07-11 | Peru | Lambayeque | 107048 | 9256 | 0 | -6.353049 | -79.824113 | 2022-07-12 04:20:51 | Lambayeque, Peru | |||
2789203 | 2789203 | 2022-07-10 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-11 04:20:46 | Lambayeque, Peru | |||
142156 | 142156 | 2022-07-09 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-10 04:20:54 | Lambayeque, Peru | |||
1417256 | 1417256 | 2022-07-08 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-09 04:20:59 | Lambayeque, Peru | |||
2741181 | 2741181 | 2022-07-07 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-08 04:20:56 | Lambayeque, Peru | |||
1199976 | 1199976 | 2022-07-06 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-07 04:20:55 | Lambayeque, Peru | |||
3966719 | 3966719 | 2022-07-05 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-06 04:20:58 | Lambayeque, Peru | |||
3078230 | 3078230 | 2022-07-04 | Peru | Lambayeque | 106454 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-05 04:20:45 | Lambayeque, Peru | |||
1767512 | 1767512 | 2022-07-03 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-04 04:20:54 | Lambayeque, Peru | |||
3365498 | 3365498 | 2022-07-02 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-03 04:20:59 | Lambayeque, Peru | |||
593827 | 593827 | 2022-07-01 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-02 04:21:16 | Lambayeque, Peru | |||
3940228 | 3940228 | 2022-06-30 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-07-01 04:21:10 | Lambayeque, Peru | |||
2490186 | 2490186 | 2022-06-29 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-30 04:21:01 | Lambayeque, Peru | |||
2239568 | 2239568 | 2022-06-28 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-29 04:20:59 | Lambayeque, Peru | |||
2147810 | 2147810 | 2022-06-27 | Peru | Lambayeque | 106148 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-28 04:20:58 | Lambayeque, Peru | |||
475611 | 475611 | 2022-06-26 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-27 04:21:00 | Lambayeque, Peru | |||
938986 | 938986 | 2022-06-25 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-26 04:21:02 | Lambayeque, Peru | |||
3346806 | 3346806 | 2022-06-24 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-25 04:20:57 | Lambayeque, Peru | |||
1648547 | 1648547 | 2022-06-23 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-24 04:20:58 | Lambayeque, Peru | |||
2187782 | 2187782 | 2022-06-22 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-23 04:20:55 | Lambayeque, Peru | |||
166213 | 166213 | 2022-06-21 | Peru | Lambayeque | 105939 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-22 04:20:54 | Lambayeque, Peru | |||
1763496 | 1763496 | 2022-06-20 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-21 04:20:56 | Lambayeque, Peru | |||
3269682 | 3269682 | 2022-06-19 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-20 04:21:01 | Lambayeque, Peru | |||
3397594 | 3397594 | 2022-06-18 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-19 04:20:51 | Lambayeque, Peru | |||
2311471 | 2311471 | 2022-06-17 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-18 04:21:10 | Lambayeque, Peru | |||
558975 | 558975 | 2022-06-16 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-17 04:20:56 | Lambayeque, Peru | |||
3982777 | 3982777 | 2022-06-15 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-16 04:20:55 | Lambayeque, Peru | |||
947018 | 947018 | 2022-06-14 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-15 04:20:54 | Lambayeque, Peru | |||
2979426 | 2979426 | 2022-06-13 | Peru | Lambayeque | 105762 | 9250 | 0 | -6.353049 | -79.824113 | 2022-06-14 04:20:52 | Lambayeque, Peru |
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]);