ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Merced" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277753 | 1277753 | 2021-05-02 | Merced | California | 6047 | 31594 | 454 |
1274506 | 1274506 | 2021-05-01 | Merced | California | 6047 | 31594 | 454 |
1271259 | 1271259 | 2021-04-30 | Merced | California | 6047 | 31594 | 454 |
1268012 | 1268012 | 2021-04-29 | Merced | California | 6047 | 31557 | 454 |
1264765 | 1264765 | 2021-04-28 | Merced | California | 6047 | 31529 | 454 |
1261518 | 1261518 | 2021-04-27 | Merced | California | 6047 | 31489 | 454 |
1258271 | 1258271 | 2021-04-26 | Merced | California | 6047 | 31452 | 454 |
1255024 | 1255024 | 2021-04-25 | Merced | California | 6047 | 31400 | 454 |
1251777 | 1251777 | 2021-04-24 | Merced | California | 6047 | 31400 | 454 |
1248530 | 1248530 | 2021-04-23 | Merced | California | 6047 | 31400 | 454 |
1245283 | 1245283 | 2021-04-22 | Merced | California | 6047 | 31358 | 454 |
1242036 | 1242036 | 2021-04-21 | Merced | California | 6047 | 31321 | 454 |
1238789 | 1238789 | 2021-04-20 | Merced | California | 6047 | 31289 | 453 |
1235542 | 1235542 | 2021-04-19 | Merced | California | 6047 | 31267 | 452 |
1232295 | 1232295 | 2021-04-18 | Merced | California | 6047 | 31196 | 452 |
1229046 | 1229046 | 2021-04-17 | Merced | California | 6047 | 31196 | 452 |
1225798 | 1225798 | 2021-04-16 | Merced | California | 6047 | 31196 | 452 |
1222551 | 1222551 | 2021-04-15 | Merced | California | 6047 | 31151 | 452 |
1219303 | 1219303 | 2021-04-14 | Merced | California | 6047 | 31128 | 450 |
1216055 | 1216055 | 2021-04-13 | Merced | California | 6047 | 31105 | 449 |
1212808 | 1212808 | 2021-04-12 | Merced | California | 6047 | 31070 | 448 |
1209560 | 1209560 | 2021-04-11 | Merced | California | 6047 | 31009 | 448 |
1206311 | 1206311 | 2021-04-10 | Merced | California | 6047 | 31009 | 448 |
1203063 | 1203063 | 2021-04-09 | Merced | California | 6047 | 31009 | 448 |
1199815 | 1199815 | 2021-04-08 | Merced | California | 6047 | 30985 | 447 |
1196566 | 1196566 | 2021-04-07 | Merced | California | 6047 | 30968 | 442 |
1193318 | 1193318 | 2021-04-06 | Merced | California | 6047 | 30939 | 442 |
1190068 | 1190068 | 2021-04-05 | Merced | California | 6047 | 30906 | 442 |
1186821 | 1186821 | 2021-04-04 | Merced | California | 6047 | 30687 | 439 |
1183574 | 1183574 | 2021-04-03 | Merced | California | 6047 | 30687 | 439 |
1180327 | 1180327 | 2021-04-02 | Merced | California | 6047 | 30687 | 439 |
1177080 | 1177080 | 2021-04-01 | Merced | California | 6047 | 30649 | 438 |
1173833 | 1173833 | 2021-03-31 | Merced | California | 6047 | 30593 | 436 |
1170586 | 1170586 | 2021-03-30 | Merced | California | 6047 | 30558 | 435 |
1167338 | 1167338 | 2021-03-29 | Merced | California | 6047 | 30521 | 435 |
1164090 | 1164090 | 2021-03-28 | Merced | California | 6047 | 30419 | 434 |
1160842 | 1160842 | 2021-03-27 | Merced | California | 6047 | 30419 | 434 |
1157594 | 1157594 | 2021-03-26 | Merced | California | 6047 | 30419 | 434 |
1154347 | 1154347 | 2021-03-25 | Merced | California | 6047 | 30372 | 432 |
1151100 | 1151100 | 2021-03-24 | Merced | California | 6047 | 30340 | 431 |
1147853 | 1147853 | 2021-03-23 | Merced | California | 6047 | 30298 | 430 |
1144606 | 1144606 | 2021-03-22 | Merced | California | 6047 | 30257 | 429 |
1141359 | 1141359 | 2021-03-21 | Merced | California | 6047 | 30142 | 428 |
1138113 | 1138113 | 2021-03-20 | Merced | California | 6047 | 30142 | 428 |
1134867 | 1134867 | 2021-03-19 | Merced | California | 6047 | 30142 | 428 |
1131620 | 1131620 | 2021-03-18 | Merced | California | 6047 | 30087 | 428 |
1128372 | 1128372 | 2021-03-17 | Merced | California | 6047 | 30027 | 425 |
1125126 | 1125126 | 2021-03-16 | Merced | California | 6047 | 29979 | 423 |
1121880 | 1121880 | 2021-03-15 | Merced | California | 6047 | 29940 | 423 |
1118633 | 1118633 | 2021-03-14 | Merced | California | 6047 | 29796 | 421 |
1115386 | 1115386 | 2021-03-13 | Merced | California | 6047 | 29796 | 421 |
1112140 | 1112140 | 2021-03-12 | Merced | California | 6047 | 29796 | 421 |
1108894 | 1108894 | 2021-03-11 | Merced | California | 6047 | 29711 | 418 |
1105648 | 1105648 | 2021-03-10 | Merced | California | 6047 | 29643 | 417 |
1102402 | 1102402 | 2021-03-09 | Merced | California | 6047 | 29600 | 416 |
1099156 | 1099156 | 2021-03-08 | Merced | California | 6047 | 29557 | 415 |
1095908 | 1095908 | 2021-03-07 | Merced | California | 6047 | 29376 | 413 |
1092662 | 1092662 | 2021-03-06 | Merced | California | 6047 | 29376 | 413 |
1089416 | 1089416 | 2021-03-05 | Merced | California | 6047 | 29376 | 413 |
1086171 | 1086171 | 2021-03-04 | Merced | California | 6047 | 29325 | 412 |
1082925 | 1082925 | 2021-03-03 | Merced | California | 6047 | 29264 | 407 |
1079679 | 1079679 | 2021-03-02 | Merced | California | 6047 | 29195 | 405 |
1076434 | 1076434 | 2021-03-01 | Merced | California | 6047 | 29147 | 401 |
1073188 | 1073188 | 2021-02-28 | Merced | California | 6047 | 28971 | 397 |
1069942 | 1069942 | 2021-02-27 | Merced | California | 6047 | 28971 | 397 |
1066697 | 1066697 | 2021-02-26 | Merced | California | 6047 | 28971 | 397 |
1063452 | 1063452 | 2021-02-25 | Merced | California | 6047 | 28915 | 395 |
1060207 | 1060207 | 2021-02-24 | Merced | California | 6047 | 28874 | 394 |
1056961 | 1056961 | 2021-02-23 | Merced | California | 6047 | 28749 | 393 |
1053715 | 1053715 | 2021-02-22 | Merced | California | 6047 | 28655 | 391 |
1050468 | 1050468 | 2021-02-21 | Merced | California | 6047 | 28489 | 388 |
1047221 | 1047221 | 2021-02-20 | Merced | California | 6047 | 28489 | 388 |
1043976 | 1043976 | 2021-02-19 | Merced | California | 6047 | 28489 | 388 |
1040731 | 1040731 | 2021-02-18 | Merced | California | 6047 | 28385 | 384 |
1037486 | 1037486 | 2021-02-17 | Merced | California | 6047 | 28306 | 382 |
1034241 | 1034241 | 2021-02-16 | Merced | California | 6047 | 28201 | 382 |
1030995 | 1030995 | 2021-02-15 | Merced | California | 6047 | 27701 | 375 |
1027748 | 1027748 | 2021-02-14 | Merced | California | 6047 | 27701 | 375 |
1024503 | 1024503 | 2021-02-13 | Merced | California | 6047 | 27701 | 375 |
1021258 | 1021258 | 2021-02-12 | Merced | California | 6047 | 27701 | 375 |
1018013 | 1018013 | 2021-02-11 | Merced | California | 6047 | 27701 | 375 |
1014768 | 1014768 | 2021-02-10 | Merced | California | 6047 | 27562 | 373 |
1011523 | 1011523 | 2021-02-09 | Merced | California | 6047 | 27509 | 367 |
1008277 | 1008277 | 2021-02-08 | Merced | California | 6047 | 27424 | 367 |
1005031 | 1005031 | 2021-02-07 | Merced | California | 6047 | 27134 | 362 |
1001785 | 1001785 | 2021-02-06 | Merced | California | 6047 | 27134 | 362 |
998539 | 998539 | 2021-02-05 | Merced | California | 6047 | 27134 | 362 |
995293 | 995293 | 2021-02-04 | Merced | California | 6047 | 27018 | 359 |
992047 | 992047 | 2021-02-03 | Merced | California | 6047 | 26914 | 359 |
988801 | 988801 | 2021-02-02 | Merced | California | 6047 | 26801 | 357 |
985554 | 985554 | 2021-02-01 | Merced | California | 6047 | 26674 | 354 |
982307 | 982307 | 2021-01-31 | Merced | California | 6047 | 26230 | 350 |
979061 | 979061 | 2021-01-30 | Merced | California | 6047 | 26230 | 350 |
975816 | 975816 | 2021-01-29 | Merced | California | 6047 | 26230 | 350 |
972571 | 972571 | 2021-01-28 | Merced | California | 6047 | 26038 | 349 |
969326 | 969326 | 2021-01-27 | Merced | California | 6047 | 25834 | 339 |
966082 | 966082 | 2021-01-26 | Merced | California | 6047 | 25743 | 332 |
962837 | 962837 | 2021-01-25 | Merced | California | 6047 | 25575 | 331 |
959592 | 959592 | 2021-01-24 | Merced | California | 6047 | 25048 | 324 |
956346 | 956346 | 2021-01-23 | Merced | California | 6047 | 25048 | 324 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);