johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Oaxaca" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016820 | 2016820 | 2022-09-20 | Mexico | Oaxaca | 149329 | 6333 | 0 | 17.0732 | -96.7266 | 2022-09-21 04:23:22 | Oaxaca, Mexico | |||
3570693 | 3570693 | 2022-09-19 | Mexico | Oaxaca | 149139 | 6332 | 0 | 17.0732 | -96.7266 | 2022-09-20 04:22:48 | Oaxaca, Mexico | |||
419432 | 419432 | 2022-09-18 | Mexico | Oaxaca | 149139 | 6332 | 0 | 17.0732 | -96.7266 | 2022-09-19 04:21:49 | Oaxaca, Mexico | |||
3373456 | 3373456 | 2022-09-17 | Mexico | Oaxaca | 149139 | 6332 | 0 | 17.0732 | -96.7266 | 2022-09-18 04:22:50 | Oaxaca, Mexico | |||
2355564 | 2355564 | 2022-09-16 | Mexico | Oaxaca | 148797 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-17 04:20:19 | Oaxaca, Mexico | |||
3986721 | 3986721 | 2022-09-15 | Mexico | Oaxaca | 148797 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-16 04:21:19 | Oaxaca, Mexico | |||
1889238 | 1889238 | 2022-09-14 | Mexico | Oaxaca | 148797 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-15 04:21:02 | Oaxaca, Mexico | |||
372293 | 372293 | 2022-09-13 | Mexico | Oaxaca | 148797 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-14 04:20:44 | Oaxaca, Mexico | |||
2394898 | 2394898 | 2022-09-12 | Mexico | Oaxaca | 148687 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-13 04:20:57 | Oaxaca, Mexico | |||
3765976 | 3765976 | 2022-09-11 | Mexico | Oaxaca | 148687 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-12 04:20:58 | Oaxaca, Mexico | |||
3824551 | 3824551 | 2022-09-10 | Mexico | Oaxaca | 148594 | 6328 | 0 | 17.0732 | -96.7266 | 2022-09-11 04:20:50 | Oaxaca, Mexico | |||
963008 | 963008 | 2022-09-09 | Mexico | Oaxaca | 148457 | 6324 | 0 | 17.0732 | -96.7266 | 2022-09-10 04:21:10 | Oaxaca, Mexico | |||
253410 | 253410 | 2022-09-08 | Mexico | Oaxaca | 148457 | 6324 | 0 | 17.0732 | -96.7266 | 2022-09-09 04:21:11 | Oaxaca, Mexico | |||
3745208 | 3745208 | 2022-09-07 | Mexico | Oaxaca | 148457 | 6324 | 0 | 17.0732 | -96.7266 | 2022-09-08 04:21:02 | Oaxaca, Mexico | |||
114848 | 114848 | 2022-09-06 | Mexico | Oaxaca | 148457 | 6324 | 0 | 17.0732 | -96.7266 | 2022-09-07 04:20:59 | Oaxaca, Mexico | |||
2633820 | 2633820 | 2022-09-05 | Mexico | Oaxaca | 148352 | 6322 | 0 | 17.0732 | -96.7266 | 2022-09-06 04:21:02 | Oaxaca, Mexico | |||
2987384 | 2987384 | 2022-09-04 | Mexico | Oaxaca | 148352 | 6322 | 0 | 17.0732 | -96.7266 | 2022-09-05 04:21:01 | Oaxaca, Mexico | |||
2713069 | 2713069 | 2022-09-03 | Mexico | Oaxaca | 148294 | 6321 | 0 | 17.0732 | -96.7266 | 2022-09-04 04:21:22 | Oaxaca, Mexico | |||
1393774 | 1393774 | 2022-09-02 | Mexico | Oaxaca | 148294 | 6321 | 0 | 17.0732 | -96.7266 | 2022-09-03 04:21:04 | Oaxaca, Mexico | |||
3547603 | 3547603 | 2022-09-01 | Mexico | Oaxaca | 148261 | 6319 | 0 | 17.0732 | -96.7266 | 2022-09-02 04:21:07 | Oaxaca, Mexico | |||
2343523 | 2343523 | 2022-08-31 | Mexico | Oaxaca | 147917 | 6315 | 0 | 17.0732 | -96.7266 | 2022-09-01 04:21:03 | Oaxaca, Mexico | |||
3774003 | 3774003 | 2022-08-30 | Mexico | Oaxaca | 147917 | 6315 | 0 | 17.0732 | -96.7266 | 2022-08-31 04:20:57 | Oaxaca, Mexico | |||
1680599 | 1680599 | 2022-08-29 | Mexico | Oaxaca | 147917 | 6315 | 0 | 17.0732 | -96.7266 | 2022-08-30 04:21:03 | Oaxaca, Mexico | |||
1877083 | 1877083 | 2022-08-28 | Mexico | Oaxaca | 147917 | 6315 | 0 | 17.0732 | -96.7266 | 2022-08-29 04:21:06 | Oaxaca, Mexico | |||
2096210 | 2096210 | 2022-08-27 | Mexico | Oaxaca | 147293 | 6312 | 0 | 17.0732 | -96.7266 | 2022-08-28 04:21:02 | Oaxaca, Mexico | |||
1532025 | 1532025 | 2022-08-26 | Mexico | Oaxaca | 147293 | 6312 | 0 | 17.0732 | -96.7266 | 2022-08-27 04:20:57 | Oaxaca, Mexico | |||
2828912 | 2828912 | 2022-08-25 | Mexico | Oaxaca | 147293 | 6312 | 0 | 17.0732 | -96.7266 | 2022-08-26 04:21:02 | Oaxaca, Mexico | |||
2323445 | 2323445 | 2022-08-24 | Mexico | Oaxaca | 147065 | 6311 | 0 | 17.0732 | -96.7266 | 2022-08-25 04:21:13 | Oaxaca, Mexico | |||
1250854 | 1250854 | 2022-08-23 | Mexico | Oaxaca | 146851 | 6310 | 0 | 17.0732 | -96.7266 | 2022-08-24 04:20:46 | Oaxaca, Mexico | |||
2852958 | 2852958 | 2022-08-22 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-23 04:20:56 | Oaxaca, Mexico | |||
2402930 | 2402930 | 2022-08-21 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-22 04:20:38 | Oaxaca, Mexico | |||
3798008 | 3798008 | 2022-08-20 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-21 04:20:44 | Oaxaca, Mexico | |||
2363594 | 2363594 | 2022-08-19 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-20 04:21:01 | Oaxaca, Mexico | |||
1161265 | 1161265 | 2022-08-18 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-19 04:20:54 | Oaxaca, Mexico | |||
3950589 | 3950589 | 2022-08-17 | Mexico | Oaxaca | 145339 | 6303 | 0 | 17.0732 | -96.7266 | 2022-08-18 04:21:11 | Oaxaca, Mexico | |||
991091 | 991091 | 2022-08-16 | Mexico | Oaxaca | 145128 | 6302 | 0 | 17.0732 | -96.7266 | 2022-08-17 04:20:59 | Oaxaca, Mexico | |||
2494130 | 2494130 | 2022-08-15 | Mexico | Oaxaca | 144653 | 6301 | 0 | 17.0732 | -96.7266 | 2022-08-16 04:20:58 | Oaxaca, Mexico | |||
3647680 | 3647680 | 2022-08-14 | Mexico | Oaxaca | 144604 | 6301 | 0 | 17.0732 | -96.7266 | 2022-08-15 04:20:59 | Oaxaca, Mexico | |||
1968686 | 1968686 | 2022-08-13 | Mexico | Oaxaca | 144546 | 6301 | 0 | 17.0732 | -96.7266 | 2022-08-14 04:20:55 | Oaxaca, Mexico | |||
2888495 | 2888495 | 2022-08-12 | Mexico | Oaxaca | 143168 | 6290 | 0 | 17.0732 | -96.7266 | 2022-08-13 04:20:52 | Oaxaca, Mexico | |||
3908100 | 3908100 | 2022-08-11 | Mexico | Oaxaca | 143168 | 6290 | 0 | 17.0732 | -96.7266 | 2022-08-12 04:20:54 | Oaxaca, Mexico | |||
1346417 | 1346417 | 2022-08-10 | Mexico | Oaxaca | 143168 | 6290 | 0 | 17.0732 | -96.7266 | 2022-08-11 04:20:49 | Oaxaca, Mexico | |||
1086172 | 1086172 | 2022-08-09 | Mexico | Oaxaca | 143168 | 6290 | 0 | 17.0732 | -96.7266 | 2022-08-10 04:20:57 | Oaxaca, Mexico | |||
3543587 | 3543587 | 2022-08-08 | Mexico | Oaxaca | 142777 | 6287 | 0 | 17.0732 | -96.7266 | 2022-08-09 04:20:34 | Oaxaca, Mexico | |||
1069990 | 1069990 | 2022-08-07 | Mexico | Oaxaca | 142573 | 6286 | 0 | 17.0732 | -96.7266 | 2022-08-08 04:21:08 | Oaxaca, Mexico | |||
1940578 | 1940578 | 2022-08-06 | Mexico | Oaxaca | 142364 | 6285 | 0 | 17.0732 | -96.7266 | 2022-08-07 04:20:54 | Oaxaca, Mexico | |||
880377 | 880377 | 2022-08-05 | Mexico | Oaxaca | 141450 | 6278 | 0 | 17.0732 | -96.7266 | 2022-08-06 04:20:56 | Oaxaca, Mexico | |||
2008788 | 2008788 | 2022-08-04 | Mexico | Oaxaca | 141450 | 6278 | 0 | 17.0732 | -96.7266 | 2022-08-05 04:20:52 | Oaxaca, Mexico | |||
1098215 | 1098215 | 2022-08-03 | Mexico | Oaxaca | 141003 | 6277 | 0 | 17.0732 | -96.7266 | 2022-08-04 04:20:58 | Oaxaca, Mexico | |||
1405140 | 1405140 | 2022-08-02 | Mexico | Oaxaca | 140524 | 6274 | 0 | 17.0732 | -96.7266 | 2022-08-03 04:20:59 | Oaxaca, Mexico | |||
3617178 | 3617178 | 2022-08-01 | Mexico | Oaxaca | 140033 | 6270 | 0 | 17.0732 | -96.7266 | 2022-08-02 04:20:53 | Oaxaca, Mexico | |||
3871658 | 3871658 | 2022-07-31 | Mexico | Oaxaca | 138569 | 6263 | 0 | 17.0732 | -96.7266 | 2022-08-01 04:21:03 | Oaxaca, Mexico | |||
674412 | 674412 | 2022-07-30 | Mexico | Oaxaca | 138569 | 6263 | 0 | 17.0732 | -96.7266 | 2022-07-31 04:21:02 | Oaxaca, Mexico | |||
1783611 | 1783611 | 2022-07-29 | Mexico | Oaxaca | 138569 | 6263 | 0 | 17.0732 | -96.7266 | 2022-07-30 04:20:42 | Oaxaca, Mexico | |||
1065974 | 1065974 | 2022-07-28 | Mexico | Oaxaca | 137879 | 6263 | 0 | 17.0732 | -96.7266 | 2022-07-29 04:20:45 | Oaxaca, Mexico | |||
2335493 | 2335493 | 2022-07-27 | Mexico | Oaxaca | 137879 | 6263 | 0 | 17.0732 | -96.7266 | 2022-07-28 04:20:56 | Oaxaca, Mexico | |||
1487683 | 1487683 | 2022-07-26 | Mexico | Oaxaca | 136590 | 6257 | 0 | 17.0732 | -96.7266 | 2022-07-27 04:21:04 | Oaxaca, Mexico | |||
2594129 | 2594129 | 2022-07-25 | Mexico | Oaxaca | 136590 | 6257 | 0 | 17.0732 | -96.7266 | 2022-07-26 04:20:58 | Oaxaca, Mexico | |||
896244 | 896244 | 2022-07-24 | Mexico | Oaxaca | 136342 | 6256 | 0 | 17.0732 | -96.7266 | 2022-07-25 04:20:51 | Oaxaca, Mexico | |||
91238 | 91238 | 2022-07-23 | Mexico | Oaxaca | 136116 | 6255 | 0 | 17.0732 | -96.7266 | 2022-07-24 04:20:47 | Oaxaca, Mexico | |||
900260 | 900260 | 2022-07-22 | Mexico | Oaxaca | 135527 | 6253 | 0 | 17.0732 | -96.7266 | 2022-07-23 04:20:53 | Oaxaca, Mexico | |||
670396 | 670396 | 2022-07-21 | Mexico | Oaxaca | 134984 | 6252 | 0 | 17.0732 | -96.7266 | 2022-07-22 04:21:15 | Oaxaca, Mexico | |||
1608359 | 1608359 | 2022-07-20 | Mexico | Oaxaca | 134350 | 6248 | 0 | 17.0732 | -96.7266 | 2022-07-21 04:21:10 | Oaxaca, Mexico | |||
958992 | 958992 | 2022-07-19 | Mexico | Oaxaca | 133815 | 6248 | 0 | 17.0732 | -96.7266 | 2022-07-20 04:20:59 | Oaxaca, Mexico | |||
3210379 | 3210379 | 2022-07-18 | Mexico | Oaxaca | 132939 | 6246 | 0 | 17.0732 | -96.7266 | 2022-07-19 04:20:58 | Oaxaca, Mexico | |||
3405554 | 3405554 | 2022-07-17 | Mexico | Oaxaca | 132939 | 6246 | 0 | 17.0732 | -96.7266 | 2022-07-18 04:20:59 | Oaxaca, Mexico | |||
2151754 | 2151754 | 2022-07-16 | Mexico | Oaxaca | 132756 | 6244 | 0 | 17.0732 | -96.7266 | 2022-07-17 04:21:15 | Oaxaca, Mexico | |||
2418987 | 2418987 | 2022-07-15 | Mexico | Oaxaca | 132241 | 6243 | 0 | 17.0732 | -96.7266 | 2022-07-16 04:21:05 | Oaxaca, Mexico | |||
3429062 | 3429062 | 2022-07-14 | Mexico | Oaxaca | 131664 | 6243 | 0 | 17.0732 | -96.7266 | 2022-07-15 04:20:53 | Oaxaca, Mexico | |||
3109582 | 3109582 | 2022-07-13 | Mexico | Oaxaca | 130996 | 6243 | 0 | 17.0732 | -96.7266 | 2022-07-14 04:20:57 | Oaxaca, Mexico | |||
630005 | 630005 | 2022-07-12 | Mexico | Oaxaca | 130419 | 6240 | 0 | 17.0732 | -96.7266 | 2022-07-13 04:20:58 | Oaxaca, Mexico | |||
1211649 | 1211649 | 2022-07-11 | Mexico | Oaxaca | 129677 | 6239 | 0 | 17.0732 | -96.7266 | 2022-07-12 04:20:51 | Oaxaca, Mexico | |||
2789131 | 2789131 | 2022-07-10 | Mexico | Oaxaca | 129460 | 6239 | 0 | 17.0732 | -96.7266 | 2022-07-11 04:20:46 | Oaxaca, Mexico | |||
142084 | 142084 | 2022-07-09 | Mexico | Oaxaca | 129281 | 6238 | 0 | 17.0732 | -96.7266 | 2022-07-10 04:20:54 | Oaxaca, Mexico | |||
1417184 | 1417184 | 2022-07-08 | Mexico | Oaxaca | 128202 | 6237 | 0 | 17.0732 | -96.7266 | 2022-07-09 04:20:59 | Oaxaca, Mexico | |||
2741109 | 2741109 | 2022-07-07 | Mexico | Oaxaca | 128202 | 6237 | 0 | 17.0732 | -96.7266 | 2022-07-08 04:20:56 | Oaxaca, Mexico | |||
1199904 | 1199904 | 2022-07-06 | Mexico | Oaxaca | 127734 | 6237 | 0 | 17.0732 | -96.7266 | 2022-07-07 04:20:55 | Oaxaca, Mexico | |||
3966647 | 3966647 | 2022-07-05 | Mexico | Oaxaca | 127286 | 6234 | 0 | 17.0732 | -96.7266 | 2022-07-06 04:20:58 | Oaxaca, Mexico | |||
3078158 | 3078158 | 2022-07-04 | Mexico | Oaxaca | 126789 | 6233 | 0 | 17.0732 | -96.7266 | 2022-07-05 04:20:45 | Oaxaca, Mexico | |||
1767440 | 1767440 | 2022-07-03 | Mexico | Oaxaca | 126675 | 6233 | 0 | 17.0732 | -96.7266 | 2022-07-04 04:20:54 | Oaxaca, Mexico | |||
3365426 | 3365426 | 2022-07-02 | Mexico | Oaxaca | 126237 | 6232 | 0 | 17.0732 | -96.7266 | 2022-07-03 04:20:59 | Oaxaca, Mexico | |||
593755 | 593755 | 2022-07-01 | Mexico | Oaxaca | 126237 | 6232 | 0 | 17.0732 | -96.7266 | 2022-07-02 04:21:16 | Oaxaca, Mexico | |||
3940156 | 3940156 | 2022-06-30 | Mexico | Oaxaca | 125805 | 6232 | 0 | 17.0732 | -96.7266 | 2022-07-01 04:21:10 | Oaxaca, Mexico | |||
2490114 | 2490114 | 2022-06-29 | Mexico | Oaxaca | 124918 | 6226 | 0 | 17.0732 | -96.7266 | 2022-06-30 04:21:01 | Oaxaca, Mexico | |||
2239496 | 2239496 | 2022-06-28 | Mexico | Oaxaca | 124918 | 6226 | 0 | 17.0732 | -96.7266 | 2022-06-29 04:20:59 | Oaxaca, Mexico | |||
2147738 | 2147738 | 2022-06-27 | Mexico | Oaxaca | 124572 | 6225 | 0 | 17.0732 | -96.7266 | 2022-06-28 04:20:58 | Oaxaca, Mexico | |||
475539 | 475539 | 2022-06-26 | Mexico | Oaxaca | 124489 | 6225 | 0 | 17.0732 | -96.7266 | 2022-06-27 04:21:00 | Oaxaca, Mexico | |||
938914 | 938914 | 2022-06-25 | Mexico | Oaxaca | 124403 | 6225 | 0 | 17.0732 | -96.7266 | 2022-06-26 04:21:02 | Oaxaca, Mexico | |||
3346734 | 3346734 | 2022-06-24 | Mexico | Oaxaca | 123910 | 6223 | 0 | 17.0732 | -96.7266 | 2022-06-25 04:20:57 | Oaxaca, Mexico | |||
1648475 | 1648475 | 2022-06-23 | Mexico | Oaxaca | 123663 | 6223 | 0 | 17.0732 | -96.7266 | 2022-06-24 04:20:58 | Oaxaca, Mexico | |||
2187710 | 2187710 | 2022-06-22 | Mexico | Oaxaca | 123316 | 6222 | 0 | 17.0732 | -96.7266 | 2022-06-23 04:20:55 | Oaxaca, Mexico | |||
166141 | 166141 | 2022-06-21 | Mexico | Oaxaca | 123316 | 6222 | 0 | 17.0732 | -96.7266 | 2022-06-22 04:20:54 | Oaxaca, Mexico | |||
1763424 | 1763424 | 2022-06-20 | Mexico | Oaxaca | 123041 | 6222 | 0 | 17.0732 | -96.7266 | 2022-06-21 04:20:56 | Oaxaca, Mexico | |||
3269610 | 3269610 | 2022-06-19 | Mexico | Oaxaca | 122982 | 6222 | 0 | 17.0732 | -96.7266 | 2022-06-20 04:21:01 | Oaxaca, Mexico | |||
3397522 | 3397522 | 2022-06-18 | Mexico | Oaxaca | 122493 | 6214 | 0 | 17.0732 | -96.7266 | 2022-06-19 04:20:51 | Oaxaca, Mexico | |||
2311399 | 2311399 | 2022-06-17 | Mexico | Oaxaca | 122493 | 6214 | 0 | 17.0732 | -96.7266 | 2022-06-18 04:21:10 | Oaxaca, Mexico | |||
558903 | 558903 | 2022-06-16 | Mexico | Oaxaca | 122493 | 6214 | 0 | 17.0732 | -96.7266 | 2022-06-17 04:20:56 | Oaxaca, Mexico | |||
3982705 | 3982705 | 2022-06-15 | Mexico | Oaxaca | 122309 | 6210 | 0 | 17.0732 | -96.7266 | 2022-06-16 04:20:55 | Oaxaca, Mexico | |||
946946 | 946946 | 2022-06-14 | Mexico | Oaxaca | 122036 | 6210 | 0 | 17.0732 | -96.7266 | 2022-06-15 04:20:54 | Oaxaca, Mexico | |||
2979354 | 2979354 | 2022-06-13 | Mexico | Oaxaca | 121761 | 6208 | 0 | 17.0732 | -96.7266 | 2022-06-14 04:20:52 | Oaxaca, Mexico |
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]);