names

23 rows where place_id = 637621

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3837535 1969650 1969650 defendant Stanwell Richard fisher 637621 637621 Stanwell, Richard, of Cowebyt, fisher 0
4833517 2306490 2306490 defendant Flaketer John, sen   637621 637621 Flaketer, John, sen, of Cowebyt, boat man 0
4869798 2317525 2317525 defendant Coward John fisher 637621 637621 Coward, John, of Cowebyt, fisher 0
4876752 2319702 2319702 defendant Tomson John laborer 637621 637621 Tomson, John, of Cowebyt, laborer 1
4892796 2324476 2324476 plaintiff Jerle Thomas   637621 637621 Jerle, Thomas, of Cowebyt 0
4892797 2324476 2324476 defendant Franke Henry laborer 637621 637621 Franke, Henry, of Cowebyt, laborer 0
4892798 2324476 2324476 defendant Pynder John laborer 637621 637621 Pynder, John, of Cowebyt, laborer 1
4929454 2335630 2335630 defendant Merydewe Richard   637621 637621 Merydewe, Richard, of Cowebyt, flax chapman 0
5072823 2378353 2378353 defendant Maryot Gilbert husbandman 637621 637621 Maryot, Gilbert, of Cowebyt, husbandman 1
5076666 2379522 2379522 defendant Auckys or Anckys Katherine widow 637621 637621 Auckys or Anckys, Katherine, of Cowebyt, widow 1
5076670 2379522 2379522 defendant Stanwell Thomas husbandman 637621 637621 Stanwell, Thomas, of Cowebyt, husbandman 5
5102170 2387058 2387058 defendant Hochonson Thomas husbandman 637621 637621 Hochonson, Thomas, of Cowebyt, husbandman 4
5104303 2387681 2387681 defendant Tomson Thomas yeoman 637621 637621 Tomson, Thomas, of Cowebyt, yeoman 0
5145828 2399915 2399915 defendant Horner John fishmonger 637621 637621 Horner, John, of Cowebyt, fishmonger 1
5145829 2399915 2399915 defendant Horner Robert fishmonger 637621 637621 Horner, Robert, of Cowebyt, fishmonger 2
5166172 2405835 2405835 defendant Horner John fishmonger 637621 637621 Horner, John, of Cowebyt, fishmonger 1
5166173 2405835 2405835 defendant Horner Robert fishmonger 637621 637621 Horner, Robert, of Cowebyt, fishmonger 2
5180923 2410161 2410161 defendant Horner John fishmonger 637621 637621 Horner, John, of Cowebyt, fishmonger 1
5180924 2410161 2410161 defendant Horner Robert fishmonger 637621 637621 Horner, Robert, of Cowebyt, fishmonger 2
5226211 2423330 2423330 defendant Horner Robert husbandman 637621 637621 Horner, Robert, of Cowebyt, husbandman 2
5267321 2435543 2435543 defendant Hartforth John yeoman 637621 637621 Hartforth, John, of Cowebyt, yeoman 0
5293870 2443175 2443175 defendant Belson Thomas husbandman 637621 637621 Belson, Thomas, of Cowebyt, husbandman 0
5567124 2524966 2524966 plaintiff Horner Robert   637621 637621 Horner, Robert, of Cowebyt 6

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