ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 136 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
743932 | 743932 | 2020-11-18 | Tyrrell | North Carolina | 37177 | 136 | 3 |
533109 | 533109 | 2020-09-14 | Currituck | North Carolina | 37053 | 136 | 0 |
529874 | 529874 | 2020-09-13 | Currituck | North Carolina | 37053 | 136 | 0 |
516989 | 516989 | 2020-09-09 | Swain | North Carolina | 37173 | 136 | 3 |
487853 | 487853 | 2020-08-31 | Jones | North Carolina | 37103 | 136 | 7 |
484574 | 484574 | 2020-08-30 | Avery | North Carolina | 37011 | 136 | 0 |
429768 | 429768 | 2020-08-13 | Washington | North Carolina | 37187 | 136 | 4 |
426543 | 426543 | 2020-08-12 | Washington | North Carolina | 37187 | 136 | 4 |
391112 | 391112 | 2020-08-01 | Polk | North Carolina | 37149 | 136 | 5 |
339772 | 339772 | 2020-07-16 | Person | North Carolina | 37145 | 136 | 1 |
330135 | 330135 | 2020-07-13 | Carteret | North Carolina | 37031 | 136 | 3 |
285851 | 285851 | 2020-06-29 | Scotland | North Carolina | 37165 | 136 | 0 |
263790 | 263790 | 2020-06-22 | Bertie | North Carolina | 37015 | 136 | 4 |
260662 | 260662 | 2020-06-21 | Bertie | North Carolina | 37015 | 136 | 4 |
257535 | 257535 | 2020-06-20 | Bertie | North Carolina | 37015 | 136 | 4 |
254412 | 254412 | 2020-06-19 | Bertie | North Carolina | 37015 | 136 | 4 |
245154 | 245154 | 2020-06-16 | Warren | North Carolina | 37185 | 136 | 2 |
226485 | 226485 | 2020-06-10 | Onslow | North Carolina | 37133 | 136 | 2 |
223385 | 223385 | 2020-06-09 | Onslow | North Carolina | 37133 | 136 | 2 |
131999 | 131999 | 2020-05-10 | Burke | North Carolina | 37023 | 136 | 11 |
126091 | 126091 | 2020-05-08 | Sampson | North Carolina | 37163 | 136 | 1 |
120100 | 120100 | 2020-05-06 | Iredell | North Carolina | 37097 | 136 | 5 |
102766 | 102766 | 2020-04-30 | Granville | North Carolina | 37077 | 136 | 5 |
99913 | 99913 | 2020-04-29 | Granville | North Carolina | 37077 | 136 | 5 |
85832 | 85832 | 2020-04-24 | Wilson | North Carolina | 37195 | 136 | 6 |
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);