names

26 rows where place_id = 590192

✎ 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
3600192 1867708 1867708 defendant Marydson Richard yeoman 590192 590192 Marydson, Richard, of Lynwode, yeoman 4
3624287 1875132 1875132 defendant Andirson Robert husbandman 590192 590192 Andirson, Robert, of Lynwode, husbandman 0
3624293 1875133 1875133 defendant Andirson Robert yeoman 590192 590192 Andirson, Robert, of Lynwode, yeoman 0
3717748 1931851 1931851 defendant Johnson John husbandman 590192 590192 Johnson, John, of Lynwode, husbandman 0
3860958 1977153 1977153 defendant Broughton Miles husbandman 590192 590192 Broughton, Miles, of Lynwode, husbandman 0
3860959 1977153 1977153 defendant Browghton Thomas husbandman 590192 590192 Browghton, Thomas, of Lynwode, husbandman 1
4585150 2226776 2226776 defendant Dyconson John   590192 590192 Dyconson, John, of Lynwode 0
4799639 2296069 2296069 defendant Wryght William husbandman 590192 590192 Wryght, William, of Lynwode, husbandman 3
4818483 2301862 2301862 defendant Waryn John husbandman 590192 590192 Waryn, John, of Lynwode, husbandman 0
4828426 2304935 2304935 plaintiff Ansell Robert merchant 590192 590192 Ansell, Robert, of Lynwode, merchant 0
4828437 2304939 2304939 plaintiff Antell Robert merchant 590192 590192 Antell, Robert, of Lynwode, merchant 0
5048325 2371133 2371133 defendant Wyche John gent 590192 590192 Wyche, John, of Lynwode, gent 0
5246726 2429205 2429205 defendant Wrenne Thomas butcher 590192 590192 Wrenne, Thomas, of Lynwode, butcher 1
5246727 2429205 2429205 defendant Chapman Thomas butcher 590192 590192 Chapman, Thomas, of Lynwode, butcher 2
5277746 2438579 2438579 defendant Scott James husbandman 590192 590192 Scott, James, of Lynwode, husbandman 0
5287598 2441399 2441399 defendant Otteley Richard husbandman 590192 590192 Otteley, Richard, of Lynwode, husbandman 1
5309629 2447920 2447920 defendant Otley Richard husbandman 590192 590192 Otley, Richard, of Lynwode, husbandman 0
5317336 2450265 2450265 plaintiff Fayreclough Thurstan   590192 590192 Fayreclough, Thurstan, of Lynwode 0
5439313 2486688 2486688 defendant Fayrclough Thurston yeoman 590192 590192 Fayrclough, Thurston, of Lynwode, yeoman 0
5453122 2490817 2490817 defendant Fayrclo_ Thurstan yeoman 590192 590192 Fayrclo_, Thurstan, of Lynwode, yeoman 0
5457641 2492185 2492185 defendant Wren Thomas yeoman 590192 590192 Wren, Thomas, of Lynwode, yeoman 0
5465090 2494464 2494464 defendant Fayrclough Thurstan yeoman 590192 590192 Fayrclough, Thurstan, of Lynwode, yeoman 0
5476609 2497999 2497999 defendant Fayrclough Thurstan yeoman 590192 590192 Fayrclough, Thurstan, of Lynwode, yeoman 0
5517712 2510379 2510379 defendant Gybson John husbandman 590192 590192 Gybson, John, of Lynwode, husbandman 0
5517713 2510379 2510379 defendant Yole John husbandman 590192 590192 Yole, John, of Lynwode, husbandman 1
5517714 2510379 2510379 defendant Buyx Richard husbandman 590192 590192 Buyx, Richard, of Lynwode, 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);