names

35 rows where place_id = 731816

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4296210 2128744 2128744 defendant Comendale George chapman 731816 731816 Comendale, George, of Newport Pagnell, Bucks, chapman 1
4694518 2263779 2263779 defendant Hakere Richard ostler 731816 731816 Hakere, Richard, of Newport Pagnell, Bucks, ostler 0
4694520 2263780 2263780 defendant Hokere Richard ostler 731816 731816 Hokere, Richard, of Newport Pagnell, Bucks, ostler 0
4714469 2269856 2269856 defendant Tynte John   731816 731816 Tynte, John, of Newport Pagnell, Bucks, shoe maker 0
4714473 2269857 2269857 defendant Tynte John   731816 731816 Tynte, John, of Newport Pagnell, Bucks, shoe amker 0
4741329 2277959 2277959 defendant Prene Walter butcher 731816 731816 Prene, Walter, of Newport Pagnell, bucks, butcher 3
4744898 2279023 2279023 defendant Belasise Richard chapman 731816 731816 Belasise, Richard, of Newport Pagnell, Bucks, chapman 3
4755889 2282224 2282224 defendant Abbey Thomas husbandman 731816 731816 Abbey, Thomas, of Newport Pagnell, Bucks, husbandman 5
4758357 2282986 2282986 defendant Belassys Richard chapman 731816 731816 Belassys, Richard, of Newport Pagnell, Bucks, chapman 2
4758994 2283165 2283165 defendant Prene Robert chapman 731816 731816 Prene, Robert, of Newport Pagnell, Bucks, chapman 0
4766925 2285645 2285645 defendant Parys John butcher 731816 731816 Parys, John, of Newport Pagnell, Bucks, butcher 3
4766950 2285650 2285650 defendant Chicche Richard butcher 731816 731816 Chicche, Richard, of Newport Pagnell, Bucks, butcher 0
4833730 2306558 2306558 defendant Peyto Thomas fuller 731816 731816 Peyto, Thomas, of Newport Pagnell, Bucks, fuller 1
4996725 2355879 2355879 defendant Levene Simon husbandman 731816 731816 Levene, Simon, of Newport Pagnell, Bucks, husbandman 2
5001285 2357255 2357255 defendant Pepyr John husbandman 731816 731816 Pepyr, John, of Newport Pagnell, Bucks, husbandman 3
5002920 2357760 2357760 defendant Fyssher John husbandman 731816 731816 Fyssher, John, of Newport Pagnell, Bucks, husbandman 0
5003242 2357848 2357848 defendant Peyto William fuller 731816 731816 Peyto, William, of Newport Pagnell, Bucks, fuller 0
5139452 2398026 2398026 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5153367 2402137 2402137 defendant Chambur John husbandman 731816 731816 Chambur, John, of Newport Pagnell, Bucks, husbandman 3
5157291 2403271 2403271 defendant Barber Robert yeoman 731816 731816 Barber, Robert, of Newport Pagnell, Bucks, yeoman 0
5157293 2403272 2403272 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5160442 2404145 2404145 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5162228 2404682 2404682 defendant Strenger William chapman 731816 731816 Strenger, William, of Newport Pagnell, Bucks, chapman 0
5162234 2404683 2404683 defendant Strenger William chapman 731816 731816 Strenger, William, of Newport Pagnell, Bucks, chapman 0
5166539 2405933 2405933 defendant Chambre Robert chapman 731816 731816 Chambre, Robert, of Newport Pagnell, Bucks, chapman 0
5170814 2407185 2407185 defendant Chambur John   731816 731816 Chambur, John, of Newport Pagnell, Bucks, husbandman, alias of Worcester 3
5173265 2407893 2407893 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5173267 2407894 2407894 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5175238 2408451 2408451 defendant Barker Robert yeoman 731816 731816 Barker, Robert, of Newport Pagnell, Bucks, yeoman 0
5176379 2408779 2408779 defendant Strenger William chapman 731816 731816 Strenger, William, of Newport Pagnell, Bucks, chapman 0
5179617 2409774 2409774 defendant Wyrall William gent 731816 731816 Wyrall, William, of Newport Pagnell, Bucks, gent 0
5185575 2411534 2411534 defendant Chamber John chapman 731816 731816 Chamber, John, of Newport Pagnell, Bucks, chapman 1
5185578 2411535 2411535 defendant Chamber John chapman 731816 731816 Chamber, John, of Newport Pagnell, Bucks, chapman 1
5201973 2416345 2416345 defendant Wyrall Willai gent 731816 731816 Wyrall, Willai, of Newport Pagnell, Bucks, gent 0
5413957 2479105 2479105 defendant Chambur Robert chapman 731816 731816 Chambur, Robert, of Newport Pagnell, Bucks, chapman 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);