names

22 rows where place_id = 592314

✎ 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
3607298 1869943 1869943 defendant Pette William merchant 592314 592314 Pette, William, of Lostwythyell, Cornw, merchant 1
3641233 1907710 1907710 defendant Menwynnek Edward gent 592314 592314 Menwynnek, Edward, of Lostwythyell, Cornw, gent 0
3687795 1922347 1922347 defendant Kendall Henry gent 592314 592314 Kendall, Henry, of Lostwythyell, Cornw, gent 0
3687798 1922348 1922348 defendant Kendall Henry gent 592314 592314 Kendall, Henry, of Lostwythyell, Cornw, gent 0
3825542 1965841 1965841 defendant Godeman John tinner 592314 592314 Godeman, John, of Lostwythyell, Cornw, tinner 0
3825544 1965842 1965842 defendant Wylstreme John tanner 592314 592314 Wylstreme, John, of Lostwythyell, Cornw, tanner 0
4264721 2117842 2117842 defendant Kendall Thomas esq 592314 592314 Kendall, Thomas, of Lostwythyell, Cornw, esq 2
4658189 2248439 2248439 defendant Hogge John merchant 592314 592314 Hogge, John, of Lostwythyell, Cornw, merchant 0
4661194 2249326 2249326 defendant Pruet Thomas laborer 592314 592314 Pruet, Thomas, of Lostwythyell, Cornw, laborer 0
4661239 2249337 2249337 defendant Pruet Thomas laborer 592314 592314 Pruet, Thomas, of Lostwythyell, Cornw, laborer 0
4793615 2294115 2294115 defendant Botreaux Ralph   592314 592314 Botreaux, Ralph, of Lostwythyell, Cornw, knight 1
4910808 2329889 2329889 defendant Kendale Thomas   592314 592314 Kendale, Thomas, of Lostwythyell, Cornw, getn 0
5066005 2376358 2376358 defendant Menwynnek William gent 592314 592314 Menwynnek, William, of Lostwythyell, Cornw, gent 0
5338208 2456517 2456517 defendant Notys Richard mariner 592314 592314 Notys, Richard, of Lostwythyell, Cornw, mariner 0
5344348 2458413 2458413 defendant Vey Robert clerk 592314 592314 Vey, Robert, of Lostwythyell, Cornw, clerk 1
5418673 2480508 2480508 defendant Menwynnek John gent 592314 592314 Menwynnek, John, of Lostwythyell, Cornw, gent 0
5420386 2481020 2481020 defendant Mynwyniek John gent 592314 592314 Mynwyniek, John, of Lostwythyell, Cornw, gent 0
5436692 2485902 2485902 defendant Menwynnek John gent 592314 592314 Menwynnek, John, of Lostwythyell, Cornw, gent 0
5451326 2490273 2490273 defendant Menwynnek John gent 592314 592314 Menwynnek, John, of Lostwythyell, Cornw, gent 0
5506081 2506823 2506823 defendant Peweterer Thomas pewterer 592314 592314 Peweterer, Thomas, of Lostwythyell, Cornw, pewterer 2
5636655 2555410 2555410 defendant Hervy Richard clerk 592314 592314 Hervy, Richard, of Lostwythyell, Cornw, clerk 3
5636725 2555432 2555432 defendant Hervy Richard clerk 592314 592314 Hervy, Richard, of Lostwythyell, Cornw, clerk 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);