names

22 rows where place_id = 679057

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4034474 2037000 2037000 defendant Gosse John gent 679057 679057 Gosse, John, of Brant Broughton, gent 0
4214023 2100424 2100424 defendant Gosse Thomas gent 679057 679057 Gosse, Thomas, of Brant Broughton, gent 0
4230522 2106171 2106171 defendant Langworthe Thomas yeoman 679057 679057 Langworthe, Thomas, of Brant Broughton, yeoman 0
4230523 2106171 2106171 defendant Small Thomas yeoman 679057 679057 Small, Thomas, of Brant Broughton, yeoman 1
4230524 2106171 2106171 defendant Langworthe Richard yeoman 679057 679057 Langworthe, Richard, of Brant Broughton, yeoman 2
4239260 2109354 2109354 defendant Langworth Thomas yeoman 679057 679057 Langworth, Thomas, of Brant Broughton, yeoman 0
4239261 2109354 2109354 defendant Small Thomas yeoman 679057 679057 Small, Thomas, of Brant Broughton, yeoman 1
4239262 2109354 2109354 defendant Langworth Richard yeoman 679057 679057 Langworth, Richard, of Brant Broughton, yeoman 2
4242881 2110610 2110610 defendant Gosse Thomas   679057 679057 Gosse, Thomas, of Brant Broughton 2
4252941 2113978 2113978 defendant Gosse Thomas gent 679057 679057 Gosse, Thomas, of Brant Broughton, gent 2
4281389 2123396 2123396 defendant Gosse Thomas gent 679057 679057 Gosse, Thomas, of Brant Broughton, gent 1
4359232 2150462 2150462 defendant Needham Richard yeoman 679057 679057 Needham, Richard, of Brant Broughton, yeoman 0
4359234 2150463 2150463 defendant Goosse Thomas yeoman 679057 679057 Goosse, Thomas, of Brant Broughton, yeoman 0
4359236 2150464 2150464 defendant Lamwith Edward yeoman 679057 679057 Lamwith, Edward, of Brant Broughton, yeoman 0
4359866 2150692 2150692 defendant Langwith William yeoman 679057 679057 Langwith, William, of Brant Broughton, yeoman 0
4371134 2154736 2154736 defendant Sutton John yeoman 679057 679057 Sutton, John, of Brant Broughton, yeoman 0
4373394 2155552 2155552 defendant Wrighte Thomas tailor 679057 679057 Wrighte, Thomas, of Brant Broughton, tailor 0
4373396 2155553 2155553 defendant Wrighte Thomas tailor 679057 679057 Wrighte, Thomas, of Brant Broughton, tailor 0
4373398 2155554 2155554 defendant Freeman John laborer 679057 679057 Freeman, John, of Brant Broughton, laborer 0
4373399 2155554 2155554 defendant Firkyn Robert laborer 679057 679057 Firkyn, Robert, of Brant Broughton, laborer 1
4932347 2336514 2336514 defendant Byrt Nicholas husbandman 679057 679057 Byrt, Nicholas, of Brant Broughton, husbandman 1
4932348 2336514 2336514 defendant Tobot John husbandman 679057 679057 Tobot, John, of Brant Broughton, husbandman 2

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);