ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1491885 | 1491885 | 2021-07-07 | Maricopa | Arizona | 4013 | 562492 | 10321 |
1488638 | 1488638 | 2021-07-06 | Maricopa | Arizona | 4013 | 562308 | 10317 |
1485391 | 1485391 | 2021-07-05 | Maricopa | Arizona | 4013 | 561596 | 10309 |
1482145 | 1482145 | 2021-07-04 | Maricopa | Arizona | 4013 | 561595 | 10309 |
1478898 | 1478898 | 2021-07-03 | Maricopa | Arizona | 4013 | 561211 | 10305 |
1475652 | 1475652 | 2021-07-02 | Maricopa | Arizona | 4013 | 560728 | 10294 |
1472406 | 1472406 | 2021-07-01 | Maricopa | Arizona | 4013 | 560446 | 10282 |
1469161 | 1469161 | 2021-06-30 | Maricopa | Arizona | 4013 | 560181 | 10280 |
1465916 | 1465916 | 2021-06-29 | Maricopa | Arizona | 4013 | 559688 | 10276 |
1462671 | 1462671 | 2021-06-28 | Maricopa | Arizona | 4013 | 559345 | 10268 |
1459426 | 1459426 | 2021-06-27 | Maricopa | Arizona | 4013 | 559045 | 10268 |
1456181 | 1456181 | 2021-06-26 | Maricopa | Arizona | 4013 | 558730 | 10269 |
1452936 | 1452936 | 2021-06-25 | Maricopa | Arizona | 4013 | 558490 | 10261 |
1449690 | 1449690 | 2021-06-24 | Maricopa | Arizona | 4013 | 558068 | 10243 |
1446445 | 1446445 | 2021-06-23 | Maricopa | Arizona | 4013 | 557651 | 10238 |
1443200 | 1443200 | 2021-06-22 | Maricopa | Arizona | 4013 | 557363 | 10234 |
1439955 | 1439955 | 2021-06-21 | Maricopa | Arizona | 4013 | 557146 | 10224 |
1436708 | 1436708 | 2021-06-20 | Maricopa | Arizona | 4013 | 556844 | 10224 |
1433461 | 1433461 | 2021-06-19 | Maricopa | Arizona | 4013 | 556507 | 10219 |
1430215 | 1430215 | 2021-06-18 | Maricopa | Arizona | 4013 | 555891 | 10193 |
1426970 | 1426970 | 2021-06-17 | Maricopa | Arizona | 4013 | 555683 | 10187 |
1423724 | 1423724 | 2021-06-16 | Maricopa | Arizona | 4013 | 555530 | 10172 |
1420477 | 1420477 | 2021-06-15 | Maricopa | Arizona | 4013 | 555223 | 10162 |
1417232 | 1417232 | 2021-06-14 | Maricopa | Arizona | 4013 | 554925 | 10157 |
1413986 | 1413986 | 2021-06-13 | Maricopa | Arizona | 4013 | 554636 | 10157 |
1410741 | 1410741 | 2021-06-12 | Maricopa | Arizona | 4013 | 554368 | 10150 |
1407496 | 1407496 | 2021-06-11 | Maricopa | Arizona | 4013 | 553957 | 10137 |
1404250 | 1404250 | 2021-06-10 | Maricopa | Arizona | 4013 | 553711 | 10137 |
1401005 | 1401005 | 2021-06-09 | Maricopa | Arizona | 4013 | 553476 | 10122 |
1397760 | 1397760 | 2021-06-08 | Maricopa | Arizona | 4013 | 553072 | 10120 |
1394513 | 1394513 | 2021-06-07 | Maricopa | Arizona | 4013 | 552781 | 10112 |
1391268 | 1391268 | 2021-06-06 | Maricopa | Arizona | 4013 | 552494 | 10112 |
1388023 | 1388023 | 2021-06-05 | Maricopa | Arizona | 4013 | 551998 | 10111 |
1384778 | 1384778 | 2021-06-04 | Maricopa | Arizona | 4013 | 551710 | 10092 |
1381532 | 1381532 | 2021-06-03 | Maricopa | Arizona | 4013 | 551509 | 10084 |
1378287 | 1378287 | 2021-06-02 | Maricopa | Arizona | 4013 | 551298 | 10080 |
1375041 | 1375041 | 2021-06-01 | Maricopa | Arizona | 4013 | 550602 | 10071 |
1371796 | 1371796 | 2021-05-31 | Maricopa | Arizona | 4013 | 550599 | 10071 |
1368550 | 1368550 | 2021-05-30 | Maricopa | Arizona | 4013 | 550334 | 10071 |
1365304 | 1365304 | 2021-05-29 | Maricopa | Arizona | 4013 | 550067 | 10069 |
1362058 | 1362058 | 2021-05-28 | Maricopa | Arizona | 4013 | 549729 | 10052 |
1358812 | 1358812 | 2021-05-27 | Maricopa | Arizona | 4013 | 549042 | 10043 |
1355566 | 1355566 | 2021-05-26 | Maricopa | Arizona | 4013 | 548519 | 10031 |
1352320 | 1352320 | 2021-05-25 | Maricopa | Arizona | 4013 | 548006 | 10022 |
1349074 | 1349074 | 2021-05-24 | Maricopa | Arizona | 4013 | 547645 | 10017 |
1345826 | 1345826 | 2021-05-23 | Maricopa | Arizona | 4013 | 547298 | 10017 |
1342578 | 1342578 | 2021-05-22 | Maricopa | Arizona | 4013 | 547035 | 10010 |
1339330 | 1339330 | 2021-05-21 | Maricopa | Arizona | 4013 | 546516 | 9999 |
1336083 | 1336083 | 2021-05-20 | Maricopa | Arizona | 4013 | 546247 | 9985 |
1332836 | 1332836 | 2021-05-19 | Maricopa | Arizona | 4013 | 545875 | 9974 |
1329589 | 1329589 | 2021-05-18 | Maricopa | Arizona | 4013 | 545468 | 9963 |
1326343 | 1326343 | 2021-05-17 | Maricopa | Arizona | 4013 | 545051 | 9955 |
1323097 | 1323097 | 2021-05-16 | Maricopa | Arizona | 4013 | 544676 | 9955 |
1319851 | 1319851 | 2021-05-15 | Maricopa | Arizona | 4013 | 544255 | 9950 |
1316603 | 1316603 | 2021-05-14 | Maricopa | Arizona | 4013 | 543928 | 9947 |
1313357 | 1313357 | 2021-05-13 | Maricopa | Arizona | 4013 | 543198 | 9940 |
1310110 | 1310110 | 2021-05-12 | Maricopa | Arizona | 4013 | 542856 | 9934 |
1306864 | 1306864 | 2021-05-11 | Maricopa | Arizona | 4013 | 542486 | 9932 |
1303618 | 1303618 | 2021-05-10 | Maricopa | Arizona | 4013 | 542072 | 9922 |
1300371 | 1300371 | 2021-05-09 | Maricopa | Arizona | 4013 | 541555 | 9922 |
1297124 | 1297124 | 2021-05-08 | Maricopa | Arizona | 4013 | 541202 | 9919 |
1293878 | 1293878 | 2021-05-07 | Maricopa | Arizona | 4013 | 540547 | 9910 |
1290632 | 1290632 | 2021-05-06 | Maricopa | Arizona | 4013 | 539926 | 9896 |
1287386 | 1287386 | 2021-05-05 | Maricopa | Arizona | 4013 | 539632 | 9889 |
1284140 | 1284140 | 2021-05-04 | Maricopa | Arizona | 4013 | 539080 | 9886 |
1280893 | 1280893 | 2021-05-03 | Maricopa | Arizona | 4013 | 538633 | 9882 |
1277646 | 1277646 | 2021-05-02 | Maricopa | Arizona | 4013 | 538124 | 9882 |
1274399 | 1274399 | 2021-05-01 | Maricopa | Arizona | 4013 | 537899 | 9876 |
1271152 | 1271152 | 2021-04-30 | Maricopa | Arizona | 4013 | 537105 | 9875 |
1267905 | 1267905 | 2021-04-29 | Maricopa | Arizona | 4013 | 536453 | 9860 |
1264658 | 1264658 | 2021-04-28 | Maricopa | Arizona | 4013 | 535862 | 9847 |
1261411 | 1261411 | 2021-04-27 | Maricopa | Arizona | 4013 | 535436 | 9840 |
1258164 | 1258164 | 2021-04-26 | Maricopa | Arizona | 4013 | 534982 | 9836 |
1254917 | 1254917 | 2021-04-25 | Maricopa | Arizona | 4013 | 534430 | 9836 |
1251670 | 1251670 | 2021-04-24 | Maricopa | Arizona | 4013 | 533916 | 9829 |
1248423 | 1248423 | 2021-04-23 | Maricopa | Arizona | 4013 | 533368 | 9813 |
1245176 | 1245176 | 2021-04-22 | Maricopa | Arizona | 4013 | 532809 | 9803 |
1241929 | 1241929 | 2021-04-21 | Maricopa | Arizona | 4013 | 532522 | 9788 |
1238682 | 1238682 | 2021-04-20 | Maricopa | Arizona | 4013 | 532133 | 9787 |
1235435 | 1235435 | 2021-04-19 | Maricopa | Arizona | 4013 | 531673 | 9767 |
1232187 | 1232187 | 2021-04-18 | Maricopa | Arizona | 4013 | 531156 | 9767 |
1228939 | 1228939 | 2021-04-17 | Maricopa | Arizona | 4013 | 530598 | 9766 |
1225691 | 1225691 | 2021-04-16 | Maricopa | Arizona | 4013 | 530405 | 9769 |
1222444 | 1222444 | 2021-04-15 | Maricopa | Arizona | 4013 | 529722 | 9750 |
1219196 | 1219196 | 2021-04-14 | Maricopa | Arizona | 4013 | 529471 | 9741 |
1215948 | 1215948 | 2021-04-13 | Maricopa | Arizona | 4013 | 529271 | 9739 |
1212701 | 1212701 | 2021-04-12 | Maricopa | Arizona | 4013 | 528888 | 9728 |
1209452 | 1209452 | 2021-04-11 | Maricopa | Arizona | 4013 | 528377 | 9728 |
1206204 | 1206204 | 2021-04-10 | Maricopa | Arizona | 4013 | 528065 | 9733 |
1202956 | 1202956 | 2021-04-09 | Maricopa | Arizona | 4013 | 527566 | 9716 |
1199708 | 1199708 | 2021-04-08 | Maricopa | Arizona | 4013 | 527197 | 9711 |
1196459 | 1196459 | 2021-04-07 | Maricopa | Arizona | 4013 | 526890 | 9694 |
1193211 | 1193211 | 2021-04-06 | Maricopa | Arizona | 4013 | 526415 | 9670 |
1189961 | 1189961 | 2021-04-05 | Maricopa | Arizona | 4013 | 526070 | 9668 |
1186714 | 1186714 | 2021-04-04 | Maricopa | Arizona | 4013 | 525666 | 9668 |
1183467 | 1183467 | 2021-04-03 | Maricopa | Arizona | 4013 | 525361 | 9663 |
1180220 | 1180220 | 2021-04-02 | Maricopa | Arizona | 4013 | 525002 | 9670 |
1176973 | 1176973 | 2021-04-01 | Maricopa | Arizona | 4013 | 524547 | 9677 |
1173726 | 1173726 | 2021-03-31 | Maricopa | Arizona | 4013 | 524386 | 9673 |
1170479 | 1170479 | 2021-03-30 | Maricopa | Arizona | 4013 | 524077 | 9657 |
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);