ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Broome" 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 |
---|---|---|---|---|---|---|---|
1055354 | 1055354 | 2021-02-22 | Broome | New York | 36007 | 14265 | 332 |
1052108 | 1052108 | 2021-02-21 | Broome | New York | 36007 | 14228 | 329 |
1048861 | 1048861 | 2021-02-20 | Broome | New York | 36007 | 14145 | 328 |
1045614 | 1045614 | 2021-02-19 | Broome | New York | 36007 | 14051 | 328 |
1042369 | 1042369 | 2021-02-18 | Broome | New York | 36007 | 13967 | 325 |
1039124 | 1039124 | 2021-02-17 | Broome | New York | 36007 | 13869 | 324 |
1035879 | 1035879 | 2021-02-16 | Broome | New York | 36007 | 13803 | 323 |
1032634 | 1032634 | 2021-02-15 | Broome | New York | 36007 | 13757 | 322 |
1029388 | 1029388 | 2021-02-14 | Broome | New York | 36007 | 13704 | 322 |
1026141 | 1026141 | 2021-02-13 | Broome | New York | 36007 | 13648 | 321 |
1022896 | 1022896 | 2021-02-12 | Broome | New York | 36007 | 13585 | 321 |
1019651 | 1019651 | 2021-02-11 | Broome | New York | 36007 | 13532 | 317 |
1016406 | 1016406 | 2021-02-10 | Broome | New York | 36007 | 13457 | 316 |
1013161 | 1013161 | 2021-02-09 | Broome | New York | 36007 | 13393 | 315 |
1009916 | 1009916 | 2021-02-08 | Broome | New York | 36007 | 13349 | 315 |
1006670 | 1006670 | 2021-02-07 | Broome | New York | 36007 | 13305 | 314 |
1003424 | 1003424 | 2021-02-06 | Broome | New York | 36007 | 13232 | 309 |
1000178 | 1000178 | 2021-02-05 | Broome | New York | 36007 | 13121 | 304 |
996932 | 996932 | 2021-02-04 | Broome | New York | 36007 | 13038 | 301 |
993686 | 993686 | 2021-02-03 | Broome | New York | 36007 | 12919 | 297 |
990440 | 990440 | 2021-02-02 | Broome | New York | 36007 | 12831 | 295 |
987194 | 987194 | 2021-02-01 | Broome | New York | 36007 | 12794 | 292 |
983947 | 983947 | 2021-01-31 | Broome | New York | 36007 | 12748 | 292 |
980700 | 980700 | 2021-01-30 | Broome | New York | 36007 | 12651 | 291 |
977454 | 977454 | 2021-01-29 | Broome | New York | 36007 | 12509 | 290 |
974209 | 974209 | 2021-01-28 | Broome | New York | 36007 | 12366 | 289 |
970964 | 970964 | 2021-01-27 | Broome | New York | 36007 | 12227 | 283 |
967719 | 967719 | 2021-01-26 | Broome | New York | 36007 | 12104 | 282 |
964475 | 964475 | 2021-01-25 | Broome | New York | 36007 | 12008 | 280 |
961230 | 961230 | 2021-01-24 | Broome | New York | 36007 | 11924 | 275 |
957985 | 957985 | 2021-01-23 | Broome | New York | 36007 | 11804 | 270 |
954739 | 954739 | 2021-01-22 | Broome | New York | 36007 | 11657 | 269 |
951494 | 951494 | 2021-01-21 | Broome | New York | 36007 | 11467 | 263 |
948249 | 948249 | 2021-01-20 | Broome | New York | 36007 | 11255 | 260 |
945002 | 945002 | 2021-01-19 | Broome | New York | 36007 | 11108 | 259 |
941756 | 941756 | 2021-01-18 | Broome | New York | 36007 | 10981 | 255 |
938511 | 938511 | 2021-01-17 | Broome | New York | 36007 | 10866 | 254 |
935266 | 935266 | 2021-01-16 | Broome | New York | 36007 | 10743 | 249 |
932021 | 932021 | 2021-01-15 | Broome | New York | 36007 | 10620 | 248 |
928776 | 928776 | 2021-01-14 | Broome | New York | 36007 | 10457 | 245 |
925531 | 925531 | 2021-01-13 | Broome | New York | 36007 | 10296 | 240 |
922285 | 922285 | 2021-01-12 | Broome | New York | 36007 | 10095 | 233 |
919040 | 919040 | 2021-01-11 | Broome | New York | 36007 | 9959 | 229 |
915795 | 915795 | 2021-01-10 | Broome | New York | 36007 | 9844 | 227 |
912550 | 912550 | 2021-01-09 | Broome | New York | 36007 | 9650 | 226 |
909305 | 909305 | 2021-01-08 | Broome | New York | 36007 | 9459 | 223 |
906060 | 906060 | 2021-01-07 | Broome | New York | 36007 | 9264 | 220 |
902814 | 902814 | 2021-01-06 | Broome | New York | 36007 | 9031 | 217 |
899569 | 899569 | 2021-01-05 | Broome | New York | 36007 | 8788 | 215 |
896324 | 896324 | 2021-01-04 | Broome | New York | 36007 | 8672 | 213 |
893078 | 893078 | 2021-01-03 | Broome | New York | 36007 | 8601 | 210 |
889832 | 889832 | 2021-01-02 | Broome | New York | 36007 | 8487 | 208 |
886585 | 886585 | 2021-01-01 | Broome | New York | 36007 | 8301 | 206 |
883340 | 883340 | 2020-12-31 | Broome | New York | 36007 | 8157 | 204 |
880095 | 880095 | 2020-12-30 | Broome | New York | 36007 | 8004 | 202 |
876850 | 876850 | 2020-12-29 | Broome | New York | 36007 | 7855 | 202 |
873605 | 873605 | 2020-12-28 | Broome | New York | 36007 | 7745 | 200 |
870360 | 870360 | 2020-12-27 | Broome | New York | 36007 | 7663 | 199 |
867115 | 867115 | 2020-12-26 | Broome | New York | 36007 | 7616 | 198 |
863870 | 863870 | 2020-12-25 | Broome | New York | 36007 | 7540 | 195 |
860625 | 860625 | 2020-12-24 | Broome | New York | 36007 | 7429 | 195 |
857380 | 857380 | 2020-12-23 | Broome | New York | 36007 | 7318 | 193 |
854135 | 854135 | 2020-12-22 | Broome | New York | 36007 | 7144 | 193 |
850890 | 850890 | 2020-12-21 | Broome | New York | 36007 | 7083 | 189 |
847645 | 847645 | 2020-12-20 | Broome | New York | 36007 | 7004 | 186 |
844400 | 844400 | 2020-12-19 | Broome | New York | 36007 | 6938 | 186 |
841154 | 841154 | 2020-12-18 | Broome | New York | 36007 | 6893 | 184 |
837909 | 837909 | 2020-12-17 | Broome | New York | 36007 | 6764 | 183 |
834663 | 834663 | 2020-12-16 | Broome | New York | 36007 | 6692 | 180 |
831417 | 831417 | 2020-12-15 | Broome | New York | 36007 | 6601 | 178 |
828170 | 828170 | 2020-12-14 | Broome | New York | 36007 | 6532 | 178 |
824924 | 824924 | 2020-12-13 | Broome | New York | 36007 | 6460 | 176 |
821677 | 821677 | 2020-12-12 | Broome | New York | 36007 | 6390 | 173 |
818431 | 818431 | 2020-12-11 | Broome | New York | 36007 | 6306 | 170 |
815185 | 815185 | 2020-12-10 | Broome | New York | 36007 | 6238 | 167 |
811940 | 811940 | 2020-12-09 | Broome | New York | 36007 | 6160 | 166 |
808695 | 808695 | 2020-12-08 | Broome | New York | 36007 | 6057 | 163 |
805450 | 805450 | 2020-12-07 | Broome | New York | 36007 | 6003 | 163 |
802205 | 802205 | 2020-12-06 | Broome | New York | 36007 | 5946 | 162 |
798960 | 798960 | 2020-12-05 | Broome | New York | 36007 | 5875 | 160 |
795715 | 795715 | 2020-12-04 | Broome | New York | 36007 | 5768 | 159 |
792470 | 792470 | 2020-12-03 | Broome | New York | 36007 | 5657 | 156 |
789225 | 789225 | 2020-12-02 | Broome | New York | 36007 | 5551 | 153 |
785980 | 785980 | 2020-12-01 | Broome | New York | 36007 | 5448 | 149 |
782736 | 782736 | 2020-11-30 | Broome | New York | 36007 | 5367 | 147 |
779490 | 779490 | 2020-11-29 | Broome | New York | 36007 | 5308 | 145 |
776245 | 776245 | 2020-11-28 | Broome | New York | 36007 | 5234 | 143 |
773000 | 773000 | 2020-11-27 | Broome | New York | 36007 | 5201 | 140 |
769755 | 769755 | 2020-11-26 | Broome | New York | 36007 | 5143 | 138 |
766509 | 766509 | 2020-11-25 | Broome | New York | 36007 | 5054 | 136 |
763264 | 763264 | 2020-11-24 | Broome | New York | 36007 | 4983 | 135 |
760019 | 760019 | 2020-11-23 | Broome | New York | 36007 | 4927 | 133 |
756773 | 756773 | 2020-11-22 | Broome | New York | 36007 | 4859 | 133 |
753526 | 753526 | 2020-11-21 | Broome | New York | 36007 | 4792 | 129 |
750280 | 750280 | 2020-11-20 | Broome | New York | 36007 | 4688 | 128 |
747034 | 747034 | 2020-11-19 | Broome | New York | 36007 | 4620 | 126 |
743788 | 743788 | 2020-11-18 | Broome | New York | 36007 | 4545 | 126 |
740541 | 740541 | 2020-11-17 | Broome | New York | 36007 | 4469 | 125 |
737296 | 737296 | 2020-11-16 | Broome | New York | 36007 | 4431 | 124 |
734052 | 734052 | 2020-11-15 | Broome | New York | 36007 | 4394 | 123 |
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);