ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,902 rows where county = "Warren" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 14
- New Jersey 788
- Kentucky 787
- New York 787
- Ohio 785
- Iowa 781
- Pennsylvania 780
- Indiana 779
- Virginia 779
- Missouri 777
- Mississippi 776
- Georgia 775
- Tennessee 775
- North Carolina 770
- Illinois 763
fips 14
county 1
- Warren · 10,902 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3532 | 3532 | 2020-03-17 | Warren | New Jersey | 34041 | 1 | 0 |
3991 | 3991 | 2020-03-18 | Warren | Kentucky | 21227 | 1 | 0 |
4128 | 4128 | 2020-03-18 | Warren | New Jersey | 34041 | 2 | 0 |
4165 | 4165 | 2020-03-18 | Warren | New York | 36113 | 1 | 0 |
4682 | 4682 | 2020-03-19 | Warren | Kentucky | 21227 | 1 | 0 |
4856 | 4856 | 2020-03-19 | Warren | New Jersey | 34041 | 4 | 0 |
4895 | 4895 | 2020-03-19 | Warren | New York | 36113 | 1 | 0 |
5496 | 5496 | 2020-03-20 | Warren | Kentucky | 21227 | 2 | 0 |
5700 | 5700 | 2020-03-20 | Warren | New Jersey | 34041 | 4 | 0 |
5746 | 5746 | 2020-03-20 | Warren | New York | 36113 | 1 | 0 |
5815 | 5815 | 2020-03-20 | Warren | Ohio | 39165 | 2 | 0 |
6444 | 6444 | 2020-03-21 | Warren | Kentucky | 21227 | 4 | 0 |
6693 | 6693 | 2020-03-21 | Warren | New Jersey | 34041 | 5 | 0 |
6741 | 6741 | 2020-03-21 | Warren | New York | 36113 | 1 | 0 |
6816 | 6816 | 2020-03-21 | Warren | Ohio | 39165 | 2 | 0 |
7518 | 7518 | 2020-03-22 | Warren | Kentucky | 21227 | 5 | 0 |
7785 | 7785 | 2020-03-22 | Warren | New Jersey | 34041 | 9 | 0 |
7837 | 7837 | 2020-03-22 | Warren | New York | 36113 | 1 | 0 |
7928 | 7928 | 2020-03-22 | Warren | Ohio | 39165 | 3 | 0 |
8681 | 8681 | 2020-03-23 | Warren | Kentucky | 21227 | 6 | 0 |
8981 | 8981 | 2020-03-23 | Warren | New Jersey | 34041 | 15 | 1 |
9037 | 9037 | 2020-03-23 | Warren | New York | 36113 | 2 | 0 |
9135 | 9135 | 2020-03-23 | Warren | Ohio | 39165 | 5 | 0 |
9914 | 9914 | 2020-03-24 | Warren | Iowa | 19181 | 1 | 0 |
9969 | 9969 | 2020-03-24 | Warren | Kentucky | 21227 | 6 | 0 |
10285 | 10285 | 2020-03-24 | Warren | New Jersey | 34041 | 15 | 1 |
10345 | 10345 | 2020-03-24 | Warren | New York | 36113 | 2 | 0 |
10451 | 10451 | 2020-03-24 | Warren | Ohio | 39165 | 7 | 0 |
11311 | 11311 | 2020-03-25 | Warren | Iowa | 19181 | 1 | 0 |
11372 | 11372 | 2020-03-25 | Warren | Kentucky | 21227 | 7 | 0 |
11717 | 11717 | 2020-03-25 | Warren | New Jersey | 34041 | 18 | 1 |
11781 | 11781 | 2020-03-25 | Warren | New York | 36113 | 2 | 0 |
11903 | 11903 | 2020-03-25 | Warren | Ohio | 39165 | 8 | 0 |
11993 | 11993 | 2020-03-25 | Warren | Pennsylvania | 42123 | 1 | 0 |
12840 | 12840 | 2020-03-26 | Warren | Indiana | 18171 | 1 | 0 |
12878 | 12878 | 2020-03-26 | Warren | Iowa | 19181 | 1 | 0 |
12946 | 12946 | 2020-03-26 | Warren | Kentucky | 21227 | 7 | 0 |
13320 | 13320 | 2020-03-26 | Warren | New Jersey | 34041 | 31 | 1 |
13384 | 13384 | 2020-03-26 | Warren | New York | 36113 | 2 | 0 |
13512 | 13512 | 2020-03-26 | Warren | Ohio | 39165 | 10 | 0 |
13615 | 13615 | 2020-03-26 | Warren | Pennsylvania | 42123 | 1 | 0 |
13921 | 13921 | 2020-03-26 | Warren | Virginia | 51187 | 2 | 0 |
14526 | 14526 | 2020-03-27 | Warren | Indiana | 18171 | 1 | 0 |
14572 | 14572 | 2020-03-27 | Warren | Iowa | 19181 | 1 | 0 |
14652 | 14652 | 2020-03-27 | Warren | Kentucky | 21227 | 8 | 0 |
15052 | 15052 | 2020-03-27 | Warren | New Jersey | 34041 | 38 | 1 |
15118 | 15118 | 2020-03-27 | Warren | New York | 36113 | 8 | 0 |
15251 | 15251 | 2020-03-27 | Warren | Ohio | 39165 | 11 | 0 |
15362 | 15362 | 2020-03-27 | Warren | Pennsylvania | 42123 | 1 | 0 |
15689 | 15689 | 2020-03-27 | Warren | Virginia | 51187 | 2 | 0 |
16328 | 16328 | 2020-03-28 | Warren | Indiana | 18171 | 1 | 0 |
16379 | 16379 | 2020-03-28 | Warren | Iowa | 19181 | 1 | 0 |
16469 | 16469 | 2020-03-28 | Warren | Kentucky | 21227 | 10 | 0 |
16804 | 16804 | 2020-03-28 | Warren | Missouri | 29219 | 1 | 0 |
16881 | 16881 | 2020-03-28 | Warren | New Jersey | 34041 | 51 | 2 |
16949 | 16949 | 2020-03-28 | Warren | New York | 36113 | 13 | 0 |
17096 | 17096 | 2020-03-28 | Warren | Ohio | 39165 | 16 | 0 |
17216 | 17216 | 2020-03-28 | Warren | Pennsylvania | 42123 | 1 | 0 |
17569 | 17569 | 2020-03-28 | Warren | Virginia | 51187 | 2 | 0 |
18233 | 18233 | 2020-03-29 | Warren | Indiana | 18171 | 2 | 0 |
18284 | 18284 | 2020-03-29 | Warren | Iowa | 19181 | 1 | 0 |
18381 | 18381 | 2020-03-29 | Warren | Kentucky | 21227 | 10 | 0 |
18667 | 18667 | 2020-03-29 | Warren | Mississippi | 28149 | 1 | 0 |
18726 | 18726 | 2020-03-29 | Warren | Missouri | 29219 | 2 | 0 |
18805 | 18805 | 2020-03-29 | Warren | New Jersey | 34041 | 56 | 2 |
18875 | 18875 | 2020-03-29 | Warren | New York | 36113 | 18 | 0 |
19030 | 19030 | 2020-03-29 | Warren | Ohio | 39165 | 20 | 0 |
19156 | 19156 | 2020-03-29 | Warren | Pennsylvania | 42123 | 1 | 0 |
19532 | 19532 | 2020-03-29 | Warren | Virginia | 51187 | 2 | 0 |
20076 | 20076 | 2020-03-30 | Warren | Georgia | 13301 | 2 | 0 |
20239 | 20239 | 2020-03-30 | Warren | Indiana | 18171 | 2 | 0 |
20296 | 20296 | 2020-03-30 | Warren | Iowa | 19181 | 1 | 0 |
20397 | 20397 | 2020-03-30 | Warren | Kentucky | 21227 | 11 | 0 |
20691 | 20691 | 2020-03-30 | Warren | Mississippi | 28149 | 1 | 0 |
20760 | 20760 | 2020-03-30 | Warren | Missouri | 29219 | 2 | 0 |
20843 | 20843 | 2020-03-30 | Warren | New Jersey | 34041 | 68 | 2 |
20914 | 20914 | 2020-03-30 | Warren | New York | 36113 | 18 | 0 |
21077 | 21077 | 2020-03-30 | Warren | Ohio | 39165 | 20 | 0 |
21207 | 21207 | 2020-03-30 | Warren | Pennsylvania | 42123 | 1 | 0 |
21360 | 21360 | 2020-03-30 | Warren | Tennessee | 47177 | 1 | 0 |
21599 | 21599 | 2020-03-30 | Warren | Virginia | 51187 | 2 | 0 |
22162 | 22162 | 2020-03-31 | Warren | Georgia | 13301 | 3 | 0 |
22334 | 22334 | 2020-03-31 | Warren | Indiana | 18171 | 2 | 1 |
22392 | 22392 | 2020-03-31 | Warren | Iowa | 19181 | 3 | 0 |
22504 | 22504 | 2020-03-31 | Warren | Kentucky | 21227 | 13 | 0 |
22809 | 22809 | 2020-03-31 | Warren | Mississippi | 28149 | 1 | 0 |
22880 | 22880 | 2020-03-31 | Warren | Missouri | 29219 | 5 | 0 |
22966 | 22966 | 2020-03-31 | Warren | New Jersey | 34041 | 76 | 2 |
23038 | 23038 | 2020-03-31 | Warren | New York | 36113 | 18 | 0 |
23210 | 23210 | 2020-03-31 | Warren | Ohio | 39165 | 21 | 0 |
23344 | 23344 | 2020-03-31 | Warren | Pennsylvania | 42123 | 1 | 0 |
23499 | 23499 | 2020-03-31 | Warren | Tennessee | 47177 | 1 | 0 |
23747 | 23747 | 2020-03-31 | Warren | Virginia | 51187 | 3 | 0 |
24328 | 24328 | 2020-04-01 | Warren | Georgia | 13301 | 4 | 0 |
24506 | 24506 | 2020-04-01 | Warren | Indiana | 18171 | 2 | 1 |
24567 | 24567 | 2020-04-01 | Warren | Iowa | 19181 | 4 | 0 |
24680 | 24680 | 2020-04-01 | Warren | Kentucky | 21227 | 17 | 0 |
24993 | 24993 | 2020-04-01 | Warren | Mississippi | 28149 | 2 | 0 |
25068 | 25068 | 2020-04-01 | Warren | Missouri | 29219 | 6 | 0 |
25157 | 25157 | 2020-04-01 | Warren | New Jersey | 34041 | 96 | 3 |
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);