ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 11001 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
683 | 683 | 2020-03-07 | District of Columbia | District of Columbia | 11001 | 1 | 0 |
779 | 779 | 2020-03-08 | District of Columbia | District of Columbia | 11001 | 1 | 0 |
896 | 896 | 2020-03-09 | District of Columbia | District of Columbia | 11001 | 4 | 0 |
1031 | 1031 | 2020-03-10 | District of Columbia | District of Columbia | 11001 | 4 | 0 |
1200 | 1200 | 2020-03-11 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1409 | 1409 | 2020-03-12 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1675 | 1675 | 2020-03-13 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1997 | 1997 | 2020-03-14 | District of Columbia | District of Columbia | 11001 | 16 | 0 |
2379 | 2379 | 2020-03-15 | District of Columbia | District of Columbia | 11001 | 17 | 0 |
2814 | 2814 | 2020-03-16 | District of Columbia | District of Columbia | 11001 | 22 | 0 |
3297 | 3297 | 2020-03-17 | District of Columbia | District of Columbia | 11001 | 31 | 0 |
3854 | 3854 | 2020-03-18 | District of Columbia | District of Columbia | 11001 | 36 | 0 |
4519 | 4519 | 2020-03-19 | District of Columbia | District of Columbia | 11001 | 39 | 0 |
5298 | 5298 | 2020-03-20 | District of Columbia | District of Columbia | 11001 | 71 | 0 |
6225 | 6225 | 2020-03-21 | District of Columbia | District of Columbia | 11001 | 77 | 1 |
7261 | 7261 | 2020-03-22 | District of Columbia | District of Columbia | 11001 | 98 | 1 |
8407 | 8407 | 2020-03-23 | District of Columbia | District of Columbia | 11001 | 116 | 2 |
9652 | 9652 | 2020-03-24 | District of Columbia | District of Columbia | 11001 | 137 | 2 |
11026 | 11026 | 2020-03-25 | District of Columbia | District of Columbia | 11001 | 183 | 2 |
12574 | 12574 | 2020-03-26 | District of Columbia | District of Columbia | 11001 | 231 | 3 |
14243 | 14243 | 2020-03-27 | District of Columbia | District of Columbia | 11001 | 267 | 3 |
16027 | 16027 | 2020-03-28 | District of Columbia | District of Columbia | 11001 | 304 | 4 |
17919 | 17919 | 2020-03-29 | District of Columbia | District of Columbia | 11001 | 342 | 5 |
19899 | 19899 | 2020-03-30 | District of Columbia | District of Columbia | 11001 | 401 | 9 |
21976 | 21976 | 2020-03-31 | District of Columbia | District of Columbia | 11001 | 495 | 9 |
24135 | 24135 | 2020-04-01 | District of Columbia | District of Columbia | 11001 | 586 | 11 |
26365 | 26365 | 2020-04-02 | District of Columbia | District of Columbia | 11001 | 653 | 12 |
28667 | 28667 | 2020-04-03 | District of Columbia | District of Columbia | 11001 | 757 | 15 |
31025 | 31025 | 2020-04-04 | District of Columbia | District of Columbia | 11001 | 902 | 21 |
33431 | 33431 | 2020-04-05 | District of Columbia | District of Columbia | 11001 | 998 | 22 |
35876 | 35876 | 2020-04-06 | District of Columbia | District of Columbia | 11001 | 1097 | 24 |
38366 | 38366 | 2020-04-07 | District of Columbia | District of Columbia | 11001 | 1211 | 24 |
40909 | 40909 | 2020-04-08 | District of Columbia | District of Columbia | 11001 | 1440 | 27 |
43483 | 43483 | 2020-04-09 | District of Columbia | District of Columbia | 11001 | 1523 | 32 |
46084 | 46084 | 2020-04-10 | District of Columbia | District of Columbia | 11001 | 1660 | 38 |
48714 | 48714 | 2020-04-11 | District of Columbia | District of Columbia | 11001 | 1778 | 47 |
51375 | 51375 | 2020-04-12 | District of Columbia | District of Columbia | 11001 | 1875 | 50 |
54055 | 54055 | 2020-04-13 | District of Columbia | District of Columbia | 11001 | 1955 | 52 |
56747 | 56747 | 2020-04-14 | District of Columbia | District of Columbia | 11001 | 2058 | 67 |
59455 | 59455 | 2020-04-15 | District of Columbia | District of Columbia | 11001 | 2197 | 72 |
62174 | 62174 | 2020-04-16 | District of Columbia | District of Columbia | 11001 | 2350 | 81 |
64907 | 64907 | 2020-04-17 | District of Columbia | District of Columbia | 11001 | 2476 | 86 |
67655 | 67655 | 2020-04-18 | District of Columbia | District of Columbia | 11001 | 2666 | 91 |
70417 | 70417 | 2020-04-19 | District of Columbia | District of Columbia | 11001 | 2793 | 96 |
73186 | 73186 | 2020-04-20 | District of Columbia | District of Columbia | 11001 | 2927 | 105 |
75962 | 75962 | 2020-04-21 | District of Columbia | District of Columbia | 11001 | 3098 | 112 |
78746 | 78746 | 2020-04-22 | District of Columbia | District of Columbia | 11001 | 3206 | 127 |
81540 | 81540 | 2020-04-23 | District of Columbia | District of Columbia | 11001 | 3361 | 139 |
84340 | 84340 | 2020-04-24 | District of Columbia | District of Columbia | 11001 | 3528 | 153 |
87148 | 87148 | 2020-04-25 | District of Columbia | District of Columbia | 11001 | 3699 | 165 |
89965 | 89965 | 2020-04-26 | District of Columbia | District of Columbia | 11001 | 3841 | 178 |
92783 | 92783 | 2020-04-27 | District of Columbia | District of Columbia | 11001 | 3892 | 185 |
95615 | 95615 | 2020-04-28 | District of Columbia | District of Columbia | 11001 | 3994 | 190 |
98460 | 98460 | 2020-04-29 | District of Columbia | District of Columbia | 11001 | 4106 | 205 |
101310 | 101310 | 2020-04-30 | District of Columbia | District of Columbia | 11001 | 4323 | 224 |
104165 | 104165 | 2020-05-01 | District of Columbia | District of Columbia | 11001 | 4658 | 231 |
107030 | 107030 | 2020-05-02 | District of Columbia | District of Columbia | 11001 | 4797 | 240 |
109899 | 109899 | 2020-05-03 | District of Columbia | District of Columbia | 11001 | 5016 | 251 |
112774 | 112774 | 2020-05-04 | District of Columbia | District of Columbia | 11001 | 5170 | 258 |
115657 | 115657 | 2020-05-05 | District of Columbia | District of Columbia | 11001 | 5322 | 264 |
118617 | 118617 | 2020-05-06 | District of Columbia | District of Columbia | 11001 | 5461 | 277 |
121586 | 121586 | 2020-05-07 | District of Columbia | District of Columbia | 11001 | 5654 | 285 |
124565 | 124565 | 2020-05-08 | District of Columbia | District of Columbia | 11001 | 5899 | 304 |
127552 | 127552 | 2020-05-09 | District of Columbia | District of Columbia | 11001 | 6102 | 311 |
130543 | 130543 | 2020-05-10 | District of Columbia | District of Columbia | 11001 | 6272 | 323 |
133534 | 133534 | 2020-05-11 | District of Columbia | District of Columbia | 11001 | 6389 | 328 |
136523 | 136523 | 2020-05-12 | District of Columbia | District of Columbia | 11001 | 6485 | 336 |
139514 | 139514 | 2020-05-13 | District of Columbia | District of Columbia | 11001 | 6584 | 350 |
142510 | 142510 | 2020-05-14 | District of Columbia | District of Columbia | 11001 | 6736 | 358 |
145510 | 145510 | 2020-05-15 | District of Columbia | District of Columbia | 11001 | 6871 | 368 |
148513 | 148513 | 2020-05-16 | District of Columbia | District of Columbia | 11001 | 7042 | 375 |
151522 | 151522 | 2020-05-17 | District of Columbia | District of Columbia | 11001 | 7123 | 383 |
154534 | 154534 | 2020-05-18 | District of Columbia | District of Columbia | 11001 | 7270 | 392 |
157550 | 157550 | 2020-05-19 | District of Columbia | District of Columbia | 11001 | 7434 | 400 |
160576 | 160576 | 2020-05-20 | District of Columbia | District of Columbia | 11001 | 7551 | 407 |
163604 | 163604 | 2020-05-21 | District of Columbia | District of Columbia | 11001 | 7788 | 412 |
166637 | 166637 | 2020-05-22 | District of Columbia | District of Columbia | 11001 | 7893 | 418 |
169674 | 169674 | 2020-05-23 | District of Columbia | District of Columbia | 11001 | 7966 | 427 |
172715 | 172715 | 2020-05-24 | District of Columbia | District of Columbia | 11001 | 8110 | 432 |
175758 | 175758 | 2020-05-25 | District of Columbia | District of Columbia | 11001 | 8225 | 440 |
178802 | 178802 | 2020-05-26 | District of Columbia | District of Columbia | 11001 | 8334 | 440 |
181846 | 181846 | 2020-05-27 | District of Columbia | District of Columbia | 11001 | 8406 | 445 |
184900 | 184900 | 2020-05-28 | District of Columbia | District of Columbia | 11001 | 8492 | 453 |
187956 | 187956 | 2020-05-29 | District of Columbia | District of Columbia | 11001 | 8538 | 460 |
191021 | 191021 | 2020-05-30 | District of Columbia | District of Columbia | 11001 | 8717 | 462 |
194088 | 194088 | 2020-05-31 | District of Columbia | District of Columbia | 11001 | 8801 | 466 |
197158 | 197158 | 2020-06-01 | District of Columbia | District of Columbia | 11001 | 8857 | 468 |
200231 | 200231 | 2020-06-02 | District of Columbia | District of Columbia | 11001 | 8886 | 470 |
203307 | 203307 | 2020-06-03 | District of Columbia | District of Columbia | 11001 | 9016 | 473 |
206387 | 206387 | 2020-06-04 | District of Columbia | District of Columbia | 11001 | 9120 | 475 |
209468 | 209468 | 2020-06-05 | District of Columbia | District of Columbia | 11001 | 9199 | 479 |
212553 | 212553 | 2020-06-06 | District of Columbia | District of Columbia | 11001 | 9269 | 483 |
215640 | 215640 | 2020-06-07 | District of Columbia | District of Columbia | 11001 | 9332 | 489 |
218731 | 218731 | 2020-06-08 | District of Columbia | District of Columbia | 11001 | 9389 | 491 |
221826 | 221826 | 2020-06-09 | District of Columbia | District of Columbia | 11001 | 9474 | 495 |
224921 | 224921 | 2020-06-10 | District of Columbia | District of Columbia | 11001 | 9537 | 499 |
228023 | 228023 | 2020-06-11 | District of Columbia | District of Columbia | 11001 | 9589 | 502 |
231126 | 231126 | 2020-06-12 | District of Columbia | District of Columbia | 11001 | 9654 | 506 |
234232 | 234232 | 2020-06-13 | District of Columbia | District of Columbia | 11001 | 9709 | 511 |
237339 | 237339 | 2020-06-14 | District of Columbia | District of Columbia | 11001 | 9767 | 515 |
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);