ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ontario" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194987 | 1194987 | 2021-04-06 | Ontario | New York | 36069 | 6490 | 91 |
1191739 | 1191739 | 2021-04-05 | Ontario | New York | 36069 | 6476 | 91 |
1188490 | 1188490 | 2021-04-04 | Ontario | New York | 36069 | 6435 | 91 |
1185243 | 1185243 | 2021-04-03 | Ontario | New York | 36069 | 6418 | 90 |
1181996 | 1181996 | 2021-04-02 | Ontario | New York | 36069 | 6390 | 90 |
1178749 | 1178749 | 2021-04-01 | Ontario | New York | 36069 | 6354 | 90 |
1175502 | 1175502 | 2021-03-31 | Ontario | New York | 36069 | 6333 | 90 |
1172255 | 1172255 | 2021-03-30 | Ontario | New York | 36069 | 6310 | 90 |
1169008 | 1169008 | 2021-03-29 | Ontario | New York | 36069 | 6297 | 90 |
1165760 | 1165760 | 2021-03-28 | Ontario | New York | 36069 | 6283 | 90 |
1162512 | 1162512 | 2021-03-27 | Ontario | New York | 36069 | 6262 | 90 |
1159263 | 1159263 | 2021-03-26 | Ontario | New York | 36069 | 6233 | 90 |
1156016 | 1156016 | 2021-03-25 | Ontario | New York | 36069 | 6210 | 90 |
1152769 | 1152769 | 2021-03-24 | Ontario | New York | 36069 | 6189 | 90 |
1149522 | 1149522 | 2021-03-23 | Ontario | New York | 36069 | 6171 | 90 |
1146275 | 1146275 | 2021-03-22 | Ontario | New York | 36069 | 6154 | 90 |
1143028 | 1143028 | 2021-03-21 | Ontario | New York | 36069 | 6146 | 90 |
1139781 | 1139781 | 2021-03-20 | Ontario | New York | 36069 | 6117 | 90 |
1136535 | 1136535 | 2021-03-19 | Ontario | New York | 36069 | 6096 | 90 |
1133289 | 1133289 | 2021-03-18 | Ontario | New York | 36069 | 6075 | 90 |
1130041 | 1130041 | 2021-03-17 | Ontario | New York | 36069 | 6054 | 90 |
1126794 | 1126794 | 2021-03-16 | Ontario | New York | 36069 | 6045 | 90 |
1123548 | 1123548 | 2021-03-15 | Ontario | New York | 36069 | 6030 | 90 |
1120302 | 1120302 | 2021-03-14 | Ontario | New York | 36069 | 6014 | 90 |
1117055 | 1117055 | 2021-03-13 | Ontario | New York | 36069 | 5989 | 90 |
1113808 | 1113808 | 2021-03-12 | Ontario | New York | 36069 | 5982 | 90 |
1110562 | 1110562 | 2021-03-11 | Ontario | New York | 36069 | 5964 | 90 |
1107316 | 1107316 | 2021-03-10 | Ontario | New York | 36069 | 5950 | 90 |
1104070 | 1104070 | 2021-03-09 | Ontario | New York | 36069 | 5935 | 90 |
1100824 | 1100824 | 2021-03-08 | Ontario | New York | 36069 | 5925 | 90 |
1097578 | 1097578 | 2021-03-07 | Ontario | New York | 36069 | 5914 | 90 |
1094330 | 1094330 | 2021-03-06 | Ontario | New York | 36069 | 5898 | 90 |
1091084 | 1091084 | 2021-03-05 | Ontario | New York | 36069 | 5876 | 90 |
1087839 | 1087839 | 2021-03-04 | Ontario | New York | 36069 | 5858 | 89 |
1084594 | 1084594 | 2021-03-03 | Ontario | New York | 36069 | 5839 | 89 |
1081348 | 1081348 | 2021-03-02 | Ontario | New York | 36069 | 5813 | 88 |
1078102 | 1078102 | 2021-03-01 | Ontario | New York | 36069 | 5801 | 88 |
1074857 | 1074857 | 2021-02-28 | Ontario | New York | 36069 | 5791 | 88 |
1071611 | 1071611 | 2021-02-27 | Ontario | New York | 36069 | 5764 | 88 |
1068365 | 1068365 | 2021-02-26 | Ontario | New York | 36069 | 5750 | 88 |
1065120 | 1065120 | 2021-02-25 | Ontario | New York | 36069 | 5731 | 88 |
1061876 | 1061876 | 2021-02-24 | Ontario | New York | 36069 | 5699 | 88 |
1058630 | 1058630 | 2021-02-23 | Ontario | New York | 36069 | 5681 | 88 |
1055384 | 1055384 | 2021-02-22 | Ontario | New York | 36069 | 5668 | 88 |
1052138 | 1052138 | 2021-02-21 | Ontario | New York | 36069 | 5646 | 88 |
1048891 | 1048891 | 2021-02-20 | Ontario | New York | 36069 | 5626 | 88 |
1045644 | 1045644 | 2021-02-19 | Ontario | New York | 36069 | 5605 | 88 |
1042399 | 1042399 | 2021-02-18 | Ontario | New York | 36069 | 5582 | 88 |
1039154 | 1039154 | 2021-02-17 | Ontario | New York | 36069 | 5554 | 88 |
1035909 | 1035909 | 2021-02-16 | Ontario | New York | 36069 | 5533 | 88 |
1032664 | 1032664 | 2021-02-15 | Ontario | New York | 36069 | 5515 | 88 |
1029418 | 1029418 | 2021-02-14 | Ontario | New York | 36069 | 5494 | 88 |
1026171 | 1026171 | 2021-02-13 | Ontario | New York | 36069 | 5470 | 88 |
1022926 | 1022926 | 2021-02-12 | Ontario | New York | 36069 | 5460 | 88 |
1019681 | 1019681 | 2021-02-11 | Ontario | New York | 36069 | 5446 | 88 |
1016436 | 1016436 | 2021-02-10 | Ontario | New York | 36069 | 5418 | 88 |
1013191 | 1013191 | 2021-02-09 | Ontario | New York | 36069 | 5397 | 88 |
1009946 | 1009946 | 2021-02-08 | Ontario | New York | 36069 | 5383 | 88 |
1006700 | 1006700 | 2021-02-07 | Ontario | New York | 36069 | 5355 | 88 |
1003454 | 1003454 | 2021-02-06 | Ontario | New York | 36069 | 5329 | 88 |
1000208 | 1000208 | 2021-02-05 | Ontario | New York | 36069 | 5300 | 88 |
996962 | 996962 | 2021-02-04 | Ontario | New York | 36069 | 5278 | 88 |
993716 | 993716 | 2021-02-03 | Ontario | New York | 36069 | 5237 | 88 |
990470 | 990470 | 2021-02-02 | Ontario | New York | 36069 | 5216 | 88 |
987224 | 987224 | 2021-02-01 | Ontario | New York | 36069 | 5205 | 87 |
983977 | 983977 | 2021-01-31 | Ontario | New York | 36069 | 5181 | 87 |
980730 | 980730 | 2021-01-30 | Ontario | New York | 36069 | 5147 | 86 |
977484 | 977484 | 2021-01-29 | Ontario | New York | 36069 | 5116 | 86 |
974239 | 974239 | 2021-01-28 | Ontario | New York | 36069 | 5080 | 85 |
970994 | 970994 | 2021-01-27 | Ontario | New York | 36069 | 5032 | 83 |
967749 | 967749 | 2021-01-26 | Ontario | New York | 36069 | 4999 | 83 |
964505 | 964505 | 2021-01-25 | Ontario | New York | 36069 | 4969 | 83 |
961260 | 961260 | 2021-01-24 | Ontario | New York | 36069 | 4939 | 83 |
958015 | 958015 | 2021-01-23 | Ontario | New York | 36069 | 4904 | 83 |
954769 | 954769 | 2021-01-22 | Ontario | New York | 36069 | 4855 | 83 |
951524 | 951524 | 2021-01-21 | Ontario | New York | 36069 | 4815 | 83 |
948279 | 948279 | 2021-01-20 | Ontario | New York | 36069 | 4770 | 82 |
945032 | 945032 | 2021-01-19 | Ontario | New York | 36069 | 4730 | 82 |
941786 | 941786 | 2021-01-18 | Ontario | New York | 36069 | 4694 | 82 |
938541 | 938541 | 2021-01-17 | Ontario | New York | 36069 | 4647 | 81 |
935296 | 935296 | 2021-01-16 | Ontario | New York | 36069 | 4592 | 79 |
932051 | 932051 | 2021-01-15 | Ontario | New York | 36069 | 4528 | 77 |
928806 | 928806 | 2021-01-14 | Ontario | New York | 36069 | 4445 | 76 |
925561 | 925561 | 2021-01-13 | Ontario | New York | 36069 | 4384 | 76 |
922315 | 922315 | 2021-01-12 | Ontario | New York | 36069 | 4336 | 76 |
919070 | 919070 | 2021-01-11 | Ontario | New York | 36069 | 4255 | 75 |
915825 | 915825 | 2021-01-10 | Ontario | New York | 36069 | 4197 | 75 |
912580 | 912580 | 2021-01-09 | Ontario | New York | 36069 | 4125 | 73 |
909335 | 909335 | 2021-01-08 | Ontario | New York | 36069 | 4036 | 73 |
906090 | 906090 | 2021-01-07 | Ontario | New York | 36069 | 3900 | 73 |
902844 | 902844 | 2021-01-06 | Ontario | New York | 36069 | 3810 | 70 |
899599 | 899599 | 2021-01-05 | Ontario | New York | 36069 | 3710 | 69 |
896354 | 896354 | 2021-01-04 | Ontario | New York | 36069 | 3652 | 67 |
893108 | 893108 | 2021-01-03 | Ontario | New York | 36069 | 3549 | 66 |
889862 | 889862 | 2021-01-02 | Ontario | New York | 36069 | 3457 | 65 |
886615 | 886615 | 2021-01-01 | Ontario | New York | 36069 | 3365 | 62 |
883370 | 883370 | 2020-12-31 | Ontario | New York | 36069 | 3254 | 62 |
880125 | 880125 | 2020-12-30 | Ontario | New York | 36069 | 3162 | 58 |
876880 | 876880 | 2020-12-29 | Ontario | New York | 36069 | 3073 | 58 |
873635 | 873635 | 2020-12-28 | Ontario | New York | 36069 | 3007 | 56 |
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);