names

31 rows where place_id = 597077

✎ 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
3627202 1903357 1903357 defendant Marshall Richard husbandman 597077 597077 Marshall, Richard, of Wharrom, husbandman 15
3627203 1903357 1903357 defendant Bowser Thomas husbandman 597077 597077 Bowser, Thomas, of Wharrom, husbandman 16
3627204 1903357 1903357 defendant Bowser John laborer 597077 597077 Bowser, John, of Wharrom, laborer 17
3627205 1903357 1903357 defendant Grey Robert husbandman 597077 597077 Grey, Robert, of Wharrom, husbandman 18
3627206 1903357 1903357 defendant Segewith Thomas laborer 597077 597077 Segewith, Thomas, of Wharrom, laborer 19
3627207 1903357 1903357 defendant grisacre Robert husbandman 597077 597077 grisacre, Robert, of Wharrom, husbandman 20
3627208 1903357 1903357 defendant Sharp William husbandman 597077 597077 Sharp, William, of Wharrom, husbandman 21
3627209 1903357 1903357 defendant Peirson Richard laborer 597077 597077 Peirson, Richard, of Wharrom, laborer 22
3627210 1903357 1903357 defendant Holtby Robert laborer 597077 597077 Holtby, Robert, of Wharrom, laborer 23
3627211 1903357 1903357 defendant Wattarman Robert laborer 597077 597077 Wattarman, Robert, of Wharrom, laborer 24
3627212 1903357 1903357 defendant Adamson William laborer 597077 597077 Adamson, William, of Wharrom, laborer 25
3627213 1903357 1903357 defendant Watson Robert laborer 597077 597077 Watson, Robert, of Wharrom, laborer 26
3627214 1903357 1903357 defendant Cowlum Thomas laborer 597077 597077 Cowlum, Thomas, of Wharrom, laborer 27
3627215 1903357 1903357 defendant Brotton Thomas laborer 597077 597077 Brotton, Thomas, of Wharrom, laborer 28
4409360 2167727 2167727 defendant Cowper alias Anderson George yeoman 597077 597077 Cowper alias Anderson, George, of Wharrom, yeoman 1
4550624 2216138 2216138 defendant Wharrom William   597077 597077 Wharrom, William, of Wharrom 3
4571236 2222574 2222574 defendant Wharrom William   597077 597077 Wharrom, William, of Wharrom 0
4736540 2276559 2276559 defendant Wharrom John husbandman 597077 597077 Wharrom, John, of Wharrom, husbandman 0
4793003 2293901 2293901 defendant de Wharrom William husbandman 597077 597077 de Wharrom, William, of Wharrom, husbandman 0
5242098 2427889 2427889 defendant Bonsor George husbandman 597077 597077 Bonsor, George, of Wharrom, husbandman 1
5594724 2533326 2533326 defendant Marshall John husbandman 597077 597077 Marshall, John, of Wharrom, husbandman 0
5594725 2533326 2533326 defendant Marchall Richard husbandman 597077 597077 Marchall, Richard, of Wharrom, husbandman 1
5594726 2533326 2533326 defendant Segwyth Thomas husbandman 597077 597077 Segwyth, Thomas, of Wharrom, husbandman 2
5594727 2533326 2533326 defendant rengros William husbandman 597077 597077 rengros, William, of Wharrom, husbandman 3
5594728 2533326 2533326 defendant Bowser Thomas husbandman 597077 597077 Bowser, Thomas, of Wharrom, husbandman 4
5594729 2533326 2533326 defendant Bowser John husbandman 597077 597077 Bowser, John, of Wharrom, husbandman 5
5594730 2533326 2533326 defendant Sharpe William laborer 597077 597077 Sharpe, William, of Wharrom, laborer 6
5594731 2533326 2533326 defendant Watson Robert husbandman 597077 597077 Watson, Robert, of Wharrom, husbandman 7
5594732 2533326 2533326 defendant Watterman Robert laborer 597077 597077 Watterman, Robert, of Wharrom, laborer 8
5594733 2533326 2533326 defendant Carter William husbandman 597077 597077 Carter, William, of Wharrom, husbandman 9
5594734 2533326 2533326 defendant Sanderson Robert laborer 597077 597077 Sanderson, Robert, of Wharrom, laborer 10

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