names

57 rows where place_id = 669877

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3994817 2022898 2022898 defendant Baitson John yeoman 669877 669877 Baitson, John, of Bridlington, yeoman 0
4016338 2030539 2030539 defendant Preston John yeoman 669877 669877 Preston, John, of Bridlington, tanner, son of Richard Preston, of Bridlington, yeoman 0
4024413 2033410 2033410 plaintiff Blackelocke Edward merchant 669877 669877 Blackelocke, Edward, of Bridlington, merchant 0
4024415 2033410 2033410 defendant Foster Christopher yeoman 669877 669877 Foster, Christopher, of Bridlington, yeoman 1
4024416 2033411 2033411 plaintiff Blackelocke Edward merchant 669877 669877 Blackelocke, Edward, of Bridlington, merchant 0
4024418 2033411 2033411 defendant Foster Chrsistopher yeoman 669877 669877 Foster, Chrsistopher, of Bridlington, yeoman 1
4024419 2033412 2033412 plaintiff Blackelocke Edward merchant 669877 669877 Blackelocke, Edward, of Bridlington, merchant 0
4024421 2033412 2033412 defendant Shypabothom Robert gent 669877 669877 Shypabothom, Robert, of Bridlington, gent 1
4028285 2034769 2034769 defendant Baytson John yeoman 669877 669877 Baytson, John, of Bridlington, yeoman 0
4062201 2046769 2046769 defendant Shippabotham Robert gent 669877 669877 Shippabotham, Robert, of Bridlington, gent 0
4072894 2050601 2050601 plaintiff Peacock Thomas yeoman 669877 669877 Peacock, Thomas, of Bridlington, yeoman 0
4081171 2053576 2053576 defendant Shyppabotham Robert gent 669877 669877 Shyppabotham, Robert, of Bridlington, gent 0
4088599 2056225 2056225 defendant Constable Robert gent 669877 669877 Constable, Robert, of Bridlington, gent 2
4088604 2056226 2056226 defendant Constable Robert gent 669877 669877 Constable, Robert, of Bridlington, gent 2
4109903 2063802 2063802 defendant Goodayll Henry husbandman 669877 669877 Goodayll, Henry, of Bridlington, husbandman 0
4110615 2064053 2064053 defendant Wilson Richard yeoman 669877 669877 Wilson, Richard, of Bridlington, yeoman 2
4117194 2066456 2066456 defendant Palmer John merchant 669877 669877 Palmer, John, of Bridlington, merchant 0
4142222 2075455 2075455 defendant Johnson William yeoman 669877 669877 Johnson, William, of Bridlington, yeoman 9
4144252 2076148 2076148 defendant Elrington Edward gent 669877 669877 Elrington, Edward, of Bridlington, gent 1
4158291 2080971 2080971 defendant Conyston Margaret sister of Robert Shippabothom, gent 669877 669877 Margaret his wife, sister of Robert Shippabothom, of Bridlington, gent 3
4158292 2080971 2080971 defendant Elrington Edward gent 669877 669877 Elrington, Edward, of Bridlington, gent 4
4159512 2081395 2081395 defendant Skelton Peter gent 669877 669877 Skelton, Peter, of Bridlington, gent 0
4161839 2082209 2082209 defendant Elyott John husbandman 669877 669877 Elyott, John, of Bridlington, husbandman 0
4163717 2082833 2082833 defendant Ruston Robert glover 669877 669877 Ruston, Robert, of Bridlington, glover 0
4169150 2084711 2084711 defendant Palmer John merchant 669877 669877 Palmer, John, of Bridlington, merchant 0
4184701 2090158 2090158 defendant Preston Thomas butcher 669877 669877 Preston, Thomas, of Bridlington, butcher 0
4192514 2092944 2092944 defendant Skelton Christopher husbandman 669877 669877 Skelton, Christopher, of Bridlington, husbandman 1
4192515 2092944 2092944 defendant Story John husbandman 669877 669877 Story, John, of Bridlington, husbandman 2
4206488 2097814 2097814 defendant Wylsonne John yeoman 669877 669877 Wylsonne, John, of Bridlington, yeoman 1
4229869 2105930 2105930 defendant Ostler Richard yeoman 669877 669877 Ostler, Richard, of Bridlington, yeoman 0
4250376 2113108 2113108 defendant Paycocke Nathaniel yeoman 669877 669877 Paycocke, Nathaniel, of Bridlington, yeoman 0
4254090 2114366 2114366 defendant Foster Ralph yeoman 669877 669877 Foster, Ralph, of Bridlington, yeoman 3
4254155 2114384 2114384 defendant Foster Ralph yeoman 669877 669877 Foster, Ralph, of Bridlington, yeoman 3
4260236 2116387 2116387 defendant Ostler Richard yeoman 669877 669877 Ostler, Richard, of Bridlington, yeoman 0
4263281 2117385 2117385 defendant Browne John yeoman 669877 669877 Browne, John, of Bridlington, yeoman 1
4263284 2117386 2117386 defendant Browne John yeoman 669877 669877 Browne, John, of Bridlington, yeoman 1
4270741 2119791 2119791 defendant Prudam George gent 669877 669877 Prudam, George, of Bridlington, gent 2
4289860 2126434 2126434 defendant Johnson Robert husbandman 669877 669877 Johnson, Robert, of Bridlington, husbandman 0
4289861 2126434 2126434 defendant Huthom Richard husbandman 669877 669877 Huthom, Richard, of Bridlington, husbandman 1
4289862 2126434 2126434 defendant Wyse Edward yeoman 669877 669877 Wyse, Edward, of Bridlington, yeoman 2
4319207 2136832 2136832 defendant Johnson Robert husbandman 669877 669877 Johnson, Robert, of Bridlington, husbandman 0
4319208 2136832 2136832 defendant Huthom Richard husbandman 669877 669877 Huthom, Richard, of Bridlington, husbandman 1
4319209 2136832 2136832 defendant Wyse Edward yeoman 669877 669877 Wyse, Edward, of Bridlington, yeoman 2
4319210 2136832 2136832 defendant Skelton Christopher gent 669877 669877 togeher with Skelton, Christopher, of Bridlington, gent 3
4323191 2138171 2138171 defendant Judson William (legal representative) 669877 669877 Judson, William, of Bridlington, draper, administratrix of 0
4339262 2143496 2143496 defendant Foster Edward butcher 669877 669877 Foster, Edward, of Bridlington, butcher 0
4346886 2146164 2146164 defendant Clerke Robert yeoman 669877 669877 Clerke, Robert, of Bridlington, yeoman 0
4355998 2149316 2149316 defendant Mason Thomas laborer 669877 669877 Mason, Thomas, of Bridlington, laborer 0
4385536 2159846 2159846 defendant Clerke Robert yeoman 669877 669877 Clerke, Robert, of Bridlington, yeoman 0
4392125 2161990 2161990 defendant Rudstone Henry yeoman 669877 669877 Rudstone, Henry, of Bridlington, yeoman 0
4392954 2162256 2162256 defendant Foster George husbandman 669877 669877 Foster, George, of Bridlington, husbandman 0
4392955 2162256 2162256 defendant Foster Ralph husbandman 669877 669877 Foster, Ralph, of Bridlington, husbandman 1
4406356 2166691 2166691 defendant Foster George yeoman 669877 669877 Foster, George, of Bridlington, yeoman 0
4406357 2166691 2166691 defendant Johnson Robert yeoman 669877 669877 Johnson, Robert, of Bridlington, yeoman 1
4406358 2166691 2166691 defendant Blacklocke Thomas yeoman 669877 669877 Blacklocke, Thomas, of Bridlington, yeoman 2
4410171 2168004 2168004 defendant Mason Thomas laborer 669877 669877 Mason, Thomas, of Bridlington, laborer 0
5138850 2397864 2397864 defendant Carnaby Richard gent 669877 669877 Carnaby, Richard, of Bridlington, gent 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);