ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
802 rows where county = "Contra Costa" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417322 | 1417322 | 2021-06-14 | Contra Costa | California | 6013 | 70358 | 810 |
1414076 | 1414076 | 2021-06-13 | Contra Costa | California | 6013 | 70328 | 810 |
1410831 | 1410831 | 2021-06-12 | Contra Costa | California | 6013 | 70276 | 808 |
1407586 | 1407586 | 2021-06-11 | Contra Costa | California | 6013 | 70228 | 807 |
1404340 | 1404340 | 2021-06-10 | Contra Costa | California | 6013 | 70168 | 805 |
1401095 | 1401095 | 2021-06-09 | Contra Costa | California | 6013 | 70116 | 803 |
1397850 | 1397850 | 2021-06-08 | Contra Costa | California | 6013 | 70048 | 817 |
1394603 | 1394603 | 2021-06-07 | Contra Costa | California | 6013 | 70003 | 817 |
1391358 | 1391358 | 2021-06-06 | Contra Costa | California | 6013 | 69945 | 817 |
1388113 | 1388113 | 2021-06-05 | Contra Costa | California | 6013 | 69886 | 816 |
1384868 | 1384868 | 2021-06-04 | Contra Costa | California | 6013 | 69827 | 816 |
1381622 | 1381622 | 2021-06-03 | Contra Costa | California | 6013 | 69791 | 814 |
1378377 | 1378377 | 2021-06-02 | Contra Costa | California | 6013 | 69745 | 813 |
1375131 | 1375131 | 2021-06-01 | Contra Costa | California | 6013 | 69693 | 813 |
1371886 | 1371886 | 2021-05-31 | Contra Costa | California | 6013 | 69676 | 813 |
1368641 | 1368641 | 2021-05-30 | Contra Costa | California | 6013 | 69663 | 813 |
1365395 | 1365395 | 2021-05-29 | Contra Costa | California | 6013 | 69635 | 813 |
1362149 | 1362149 | 2021-05-28 | Contra Costa | California | 6013 | 69574 | 813 |
1358902 | 1358902 | 2021-05-27 | Contra Costa | California | 6013 | 69532 | 812 |
1355656 | 1355656 | 2021-05-26 | Contra Costa | California | 6013 | 69496 | 809 |
1352410 | 1352410 | 2021-05-25 | Contra Costa | California | 6013 | 69454 | 809 |
1349164 | 1349164 | 2021-05-24 | Contra Costa | California | 6013 | 69392 | 809 |
1345917 | 1345917 | 2021-05-23 | Contra Costa | California | 6013 | 69357 | 809 |
1342669 | 1342669 | 2021-05-22 | Contra Costa | California | 6013 | 69288 | 810 |
1339421 | 1339421 | 2021-05-21 | Contra Costa | California | 6013 | 69245 | 809 |
1336174 | 1336174 | 2021-05-20 | Contra Costa | California | 6013 | 69197 | 808 |
1332927 | 1332927 | 2021-05-19 | Contra Costa | California | 6013 | 69120 | 808 |
1329680 | 1329680 | 2021-05-18 | Contra Costa | California | 6013 | 69035 | 805 |
1326433 | 1326433 | 2021-05-17 | Contra Costa | California | 6013 | 69002 | 805 |
1323187 | 1323187 | 2021-05-16 | Contra Costa | California | 6013 | 68976 | 805 |
1319941 | 1319941 | 2021-05-15 | Contra Costa | California | 6013 | 68942 | 806 |
1316694 | 1316694 | 2021-05-14 | Contra Costa | California | 6013 | 68871 | 806 |
1313447 | 1313447 | 2021-05-13 | Contra Costa | California | 6013 | 68803 | 805 |
1310200 | 1310200 | 2021-05-12 | Contra Costa | California | 6013 | 68741 | 806 |
1306954 | 1306954 | 2021-05-11 | Contra Costa | California | 6013 | 68689 | 806 |
1303708 | 1303708 | 2021-05-10 | Contra Costa | California | 6013 | 68638 | 806 |
1300461 | 1300461 | 2021-05-09 | Contra Costa | California | 6013 | 68582 | 803 |
1297214 | 1297214 | 2021-05-08 | Contra Costa | California | 6013 | 68503 | 804 |
1293968 | 1293968 | 2021-05-07 | Contra Costa | California | 6013 | 68437 | 802 |
1290722 | 1290722 | 2021-05-06 | Contra Costa | California | 6013 | 68359 | 803 |
1287476 | 1287476 | 2021-05-05 | Contra Costa | California | 6013 | 68279 | 799 |
1284230 | 1284230 | 2021-05-04 | Contra Costa | California | 6013 | 68212 | 799 |
1280983 | 1280983 | 2021-05-03 | Contra Costa | California | 6013 | 68167 | 800 |
1277736 | 1277736 | 2021-05-02 | Contra Costa | California | 6013 | 68115 | 800 |
1274489 | 1274489 | 2021-05-01 | Contra Costa | California | 6013 | 68051 | 800 |
1271242 | 1271242 | 2021-04-30 | Contra Costa | California | 6013 | 67957 | 795 |
1267995 | 1267995 | 2021-04-29 | Contra Costa | California | 6013 | 67880 | 795 |
1264748 | 1264748 | 2021-04-28 | Contra Costa | California | 6013 | 67816 | 791 |
1261501 | 1261501 | 2021-04-27 | Contra Costa | California | 6013 | 67746 | 789 |
1258254 | 1258254 | 2021-04-26 | Contra Costa | California | 6013 | 67670 | 789 |
1255007 | 1255007 | 2021-04-25 | Contra Costa | California | 6013 | 67587 | 789 |
1251760 | 1251760 | 2021-04-24 | Contra Costa | California | 6013 | 67492 | 785 |
1248513 | 1248513 | 2021-04-23 | Contra Costa | California | 6013 | 67435 | 782 |
1245266 | 1245266 | 2021-04-22 | Contra Costa | California | 6013 | 67300 | 782 |
1242019 | 1242019 | 2021-04-21 | Contra Costa | California | 6013 | 67223 | 782 |
1238772 | 1238772 | 2021-04-20 | Contra Costa | California | 6013 | 67157 | 782 |
1235525 | 1235525 | 2021-04-19 | Contra Costa | California | 6013 | 67101 | 782 |
1232278 | 1232278 | 2021-04-18 | Contra Costa | California | 6013 | 67019 | 782 |
1229029 | 1229029 | 2021-04-17 | Contra Costa | California | 6013 | 66927 | 782 |
1225781 | 1225781 | 2021-04-16 | Contra Costa | California | 6013 | 66839 | 781 |
1222534 | 1222534 | 2021-04-15 | Contra Costa | California | 6013 | 66750 | 781 |
1219286 | 1219286 | 2021-04-14 | Contra Costa | California | 6013 | 66666 | 778 |
1216038 | 1216038 | 2021-04-13 | Contra Costa | California | 6013 | 66567 | 777 |
1212791 | 1212791 | 2021-04-12 | Contra Costa | California | 6013 | 66442 | 777 |
1209543 | 1209543 | 2021-04-11 | Contra Costa | California | 6013 | 66369 | 778 |
1206294 | 1206294 | 2021-04-10 | Contra Costa | California | 6013 | 66262 | 777 |
1203046 | 1203046 | 2021-04-09 | Contra Costa | California | 6013 | 66118 | 775 |
1199798 | 1199798 | 2021-04-08 | Contra Costa | California | 6013 | 65967 | 775 |
1196549 | 1196549 | 2021-04-07 | Contra Costa | California | 6013 | 65882 | 774 |
1193301 | 1193301 | 2021-04-06 | Contra Costa | California | 6013 | 65835 | 774 |
1190051 | 1190051 | 2021-04-05 | Contra Costa | California | 6013 | 65718 | 774 |
1186804 | 1186804 | 2021-04-04 | Contra Costa | California | 6013 | 65668 | 774 |
1183557 | 1183557 | 2021-04-03 | Contra Costa | California | 6013 | 65598 | 774 |
1180310 | 1180310 | 2021-04-02 | Contra Costa | California | 6013 | 65559 | 771 |
1177063 | 1177063 | 2021-04-01 | Contra Costa | California | 6013 | 65435 | 769 |
1173816 | 1173816 | 2021-03-31 | Contra Costa | California | 6013 | 65370 | 767 |
1170569 | 1170569 | 2021-03-30 | Contra Costa | California | 6013 | 65303 | 767 |
1167321 | 1167321 | 2021-03-29 | Contra Costa | California | 6013 | 65230 | 767 |
1164073 | 1164073 | 2021-03-28 | Contra Costa | California | 6013 | 65140 | 767 |
1160825 | 1160825 | 2021-03-27 | Contra Costa | California | 6013 | 65065 | 761 |
1157577 | 1157577 | 2021-03-26 | Contra Costa | California | 6013 | 64961 | 757 |
1154330 | 1154330 | 2021-03-25 | Contra Costa | California | 6013 | 64869 | 755 |
1151083 | 1151083 | 2021-03-24 | Contra Costa | California | 6013 | 64801 | 750 |
1147836 | 1147836 | 2021-03-23 | Contra Costa | California | 6013 | 64752 | 740 |
1144589 | 1144589 | 2021-03-22 | Contra Costa | California | 6013 | 64695 | 740 |
1141342 | 1141342 | 2021-03-21 | Contra Costa | California | 6013 | 64642 | 734 |
1138096 | 1138096 | 2021-03-20 | Contra Costa | California | 6013 | 64573 | 737 |
1134850 | 1134850 | 2021-03-19 | Contra Costa | California | 6013 | 64454 | 739 |
1131603 | 1131603 | 2021-03-18 | Contra Costa | California | 6013 | 64358 | 737 |
1128355 | 1128355 | 2021-03-17 | Contra Costa | California | 6013 | 64280 | 736 |
1125109 | 1125109 | 2021-03-16 | Contra Costa | California | 6013 | 64203 | 732 |
1121863 | 1121863 | 2021-03-15 | Contra Costa | California | 6013 | 64096 | 731 |
1118616 | 1118616 | 2021-03-14 | Contra Costa | California | 6013 | 64056 | 731 |
1115369 | 1115369 | 2021-03-13 | Contra Costa | California | 6013 | 63830 | 728 |
1112123 | 1112123 | 2021-03-12 | Contra Costa | California | 6013 | 63830 | 716 |
1108877 | 1108877 | 2021-03-11 | Contra Costa | California | 6013 | 63712 | 716 |
1105631 | 1105631 | 2021-03-10 | Contra Costa | California | 6013 | 63626 | 713 |
1102385 | 1102385 | 2021-03-09 | Contra Costa | California | 6013 | 63567 | 712 |
1099139 | 1099139 | 2021-03-08 | Contra Costa | California | 6013 | 63493 | 708 |
1095891 | 1095891 | 2021-03-07 | Contra Costa | California | 6013 | 63400 | 708 |
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);