battle, siege, or offensive conflict dates estimated number of americans killed
battle , siege , or offensive
conflict
dates
estimated number of americans killed
first second
minimum_number minimum_parsed minimum_day minimum_month minimum_year maximum_number maximum_parsed maximum_day maximum_month maximum_year
first second first_number second_list second_length second_list_number
text(text) text timespan unitnum(<a, unitnum>)
d-day (first day of operation overlord) world war i september 26 to november 11, 1918 7,863 killed (3,155 union and 4,708 confederacy)
how many battles resulted between 3,000 and 4,200 estimated americans killed ?
WRB JJ NNS VBD IN CD CC CD VBN NNPS VBN .
6
select count ( c1 ) from w where c4_first_number > 3000 and c4_first_number < 4200