ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "New York City" and state = "New York" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
417 | 417 | 2020-03-01 | New York City | New York | 1 | 0 | |
449 | 449 | 2020-03-02 | New York City | New York | 1 | 0 | |
483 | 483 | 2020-03-03 | New York City | New York | 2 | 0 | |
519 | 519 | 2020-03-04 | New York City | New York | 2 | 0 | |
566 | 566 | 2020-03-05 | New York City | New York | 4 | 0 | |
628 | 628 | 2020-03-06 | New York City | New York | 5 | 0 | |
716 | 716 | 2020-03-07 | New York City | New York | 12 | 0 | |
821 | 821 | 2020-03-08 | New York City | New York | 14 | 0 | |
948 | 948 | 2020-03-09 | New York City | New York | 20 | 0 | |
1099 | 1099 | 2020-03-10 | New York City | New York | 37 | 0 | |
1286 | 1286 | 2020-03-11 | New York City | New York | 52 | 0 | |
1522 | 1522 | 2020-03-12 | New York City | New York | 96 | 0 | |
1815 | 1815 | 2020-03-13 | New York City | New York | 155 | 0 | |
2164 | 2164 | 2020-03-14 | New York City | New York | 269 | 1 | |
2575 | 2575 | 2020-03-15 | New York City | New York | 330 | 5 | |
3034 | 3034 | 2020-03-16 | New York City | New York | 464 | 7 | |
3550 | 3550 | 2020-03-17 | New York City | New York | 646 | 11 | |
4151 | 4151 | 2020-03-18 | New York City | New York | 1344 | 25 | |
4880 | 4880 | 2020-03-19 | New York City | New York | 2477 | 31 | |
5729 | 5729 | 2020-03-20 | New York City | New York | 4419 | 54 | |
6723 | 6723 | 2020-03-21 | New York City | New York | 6226 | 75 | |
7818 | 7818 | 2020-03-22 | New York City | New York | 9065 | 119 | |
9016 | 9016 | 2020-03-23 | New York City | New York | 12329 | 155 | |
10323 | 10323 | 2020-03-24 | New York City | New York | 14943 | 230 | |
11759 | 11759 | 2020-03-25 | New York City | New York | 20061 | 330 | |
13362 | 13362 | 2020-03-26 | New York City | New York | 23182 | 435 | |
15096 | 15096 | 2020-03-27 | New York City | New York | 25509 | 560 | |
16926 | 16926 | 2020-03-28 | New York City | New York | 30919 | 825 | |
18851 | 18851 | 2020-03-29 | New York City | New York | 33983 | 991 | |
20890 | 20890 | 2020-03-30 | New York City | New York | 38375 | 1202 | |
23013 | 23013 | 2020-03-31 | New York City | New York | 43518 | 1475 | |
25207 | 25207 | 2020-04-01 | New York City | New York | 47914 | 1848 | |
27467 | 27467 | 2020-04-02 | New York City | New York | 52400 | 2152 | |
29791 | 29791 | 2020-04-03 | New York City | New York | 57941 | 2648 | |
32177 | 32177 | 2020-04-04 | New York City | New York | 64274 | 3221 | |
34608 | 34608 | 2020-04-05 | New York City | New York | 68726 | 3646 | |
37078 | 37078 | 2020-04-06 | New York City | New York | 73553 | 4857 | |
39593 | 39593 | 2020-04-07 | New York City | New York | 78498 | 5631 | |
42150 | 42150 | 2020-04-08 | New York City | New York | 83673 | 6441 | |
44733 | 44733 | 2020-04-09 | New York City | New York | 89127 | 7249 | |
47346 | 47346 | 2020-04-10 | New York City | New York | 94702 | 7981 | |
50001 | 50001 | 2020-04-11 | New York City | New York | 100840 | 8734 | |
52674 | 52674 | 2020-04-12 | New York City | New York | 105939 | 9448 | |
55357 | 55357 | 2020-04-13 | New York City | New York | 109706 | 10096 | |
58057 | 58057 | 2020-04-14 | New York City | New York | 113632 | 10857 | |
60771 | 60771 | 2020-04-15 | New York City | New York | 121653 | 11566 | |
63497 | 63497 | 2020-04-16 | New York City | New York | 126623 | 12109 | |
66239 | 66239 | 2020-04-17 | New York City | New York | 131003 | 12283 | |
68996 | 68996 | 2020-04-18 | New York City | New York | 135052 | 12411 | |
71763 | 71763 | 2020-04-19 | New York City | New York | 138370 | 13632 | |
74538 | 74538 | 2020-04-20 | New York City | New York | 140881 | 14074 | |
77319 | 77319 | 2020-04-21 | New York City | New York | 143547 | 14513 | |
80108 | 80108 | 2020-04-22 | New York City | New York | 146787 | 14959 | |
82907 | 82907 | 2020-04-23 | New York City | New York | 150327 | 15361 | |
85711 | 85711 | 2020-04-24 | New York City | New York | 155081 | 15754 | |
88523 | 88523 | 2020-04-25 | New York City | New York | 159851 | 16146 | |
91338 | 91338 | 2020-04-26 | New York City | New York | 163106 | 16486 | |
94163 | 94163 | 2020-04-27 | New York City | New York | 165463 | 16821 | |
96999 | 96999 | 2020-04-28 | New York City | New York | 167487 | 17206 | |
99846 | 99846 | 2020-04-29 | New York City | New York | 170124 | 17597 | |
102699 | 102699 | 2020-04-30 | New York City | New York | 172784 | 17809 | |
105561 | 105561 | 2020-05-01 | New York City | New York | 174931 | 17931 | |
108428 | 108428 | 2020-05-02 | New York City | New York | 177490 | 18021 | |
111301 | 111301 | 2020-05-03 | New York City | New York | 179728 | 18451 | |
114182 | 114182 | 2020-05-04 | New York City | New York | 181034 | 18580 | |
117062 | 117062 | 2020-05-05 | New York City | New York | 182318 | 18719 | |
120023 | 120023 | 2020-05-06 | New York City | New York | 183770 | 18993 | |
122998 | 122998 | 2020-05-07 | New York City | New York | 185653 | 19141 | |
125981 | 125981 | 2020-05-08 | New York City | New York | 187157 | 19210 | |
128970 | 128970 | 2020-05-09 | New York City | New York | 188663 | 19324 | |
131959 | 131959 | 2020-05-10 | New York City | New York | 189656 | 19436 | |
134950 | 134950 | 2020-05-11 | New York City | New York | 190546 | 19563 | |
137940 | 137940 | 2020-05-12 | New York City | New York | 191320 | 19736 | |
140936 | 140936 | 2020-05-13 | New York City | New York | 192394 | 19815 | |
143931 | 143931 | 2020-05-14 | New York City | New York | 193663 | 19904 | |
146932 | 146932 | 2020-05-15 | New York City | New York | 195472 | 19972 | |
149939 | 149939 | 2020-05-16 | New York City | New York | 196481 | 20071 | |
152949 | 152949 | 2020-05-17 | New York City | New York | 197486 | 20214 | |
155966 | 155966 | 2020-05-18 | New York City | New York | 198114 | 20298 | |
158984 | 158984 | 2020-05-19 | New York City | New York | 198710 | 20376 | |
162011 | 162011 | 2020-05-20 | New York City | New York | 199392 | 20422 | |
165040 | 165040 | 2020-05-21 | New York City | New York | 200507 | 20491 | |
168075 | 168075 | 2020-05-22 | New York City | New York | 201298 | 20569 | |
171114 | 171114 | 2020-05-23 | New York City | New York | 202062 | 20621 | |
174156 | 174156 | 2020-05-24 | New York City | New York | 202931 | 20697 | |
177200 | 177200 | 2020-05-25 | New York City | New York | 203569 | 20740 | |
180243 | 180243 | 2020-05-26 | New York City | New York | 204111 | 20795 | |
183291 | 183291 | 2020-05-27 | New York City | New York | 204781 | 20844 | |
186348 | 186348 | 2020-05-28 | New York City | New York | 205854 | 20895 | |
189408 | 189408 | 2020-05-29 | New York City | New York | 206800 | 20960 | |
192472 | 192472 | 2020-05-30 | New York City | New York | 207539 | 20991 | |
195542 | 195542 | 2020-05-31 | New York City | New York | 208085 | 21050 | |
198615 | 198615 | 2020-06-01 | New York City | New York | 208550 | 21090 | |
201689 | 201689 | 2020-06-02 | New York City | New York | 209195 | 21132 | |
204766 | 204766 | 2020-06-03 | New York City | New York | 209688 | 21170 | |
207847 | 207847 | 2020-06-04 | New York City | New York | 210227 | 21234 | |
210929 | 210929 | 2020-06-05 | New York City | New York | 210728 | 21262 | |
214013 | 214013 | 2020-06-06 | New York City | New York | 211274 | 21294 | |
217103 | 217103 | 2020-06-07 | New York City | New York | 211728 | 21323 | |
220195 | 220195 | 2020-06-08 | New York City | New York | 212122 | 21356 |
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);