names

22 rows where place_id = 589824

✎ 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
3598897 1867281 1867281 defendant Tagell Nicholas husbandman 589824 589824 Tagell, Nicholas, of Macchyng, husbandman 2
3763209 1946128 1946128 defendant Fanne Richard husbandman 589824 589824 Fanne, Richard, of Macchyng, husbandman 0
4422851 2172007 2172007 defendant Tegel John   589824 589824 Tegel, John, of Macchyng 0
4422855 2172007 2172007 defendant Veer Nicholas de   589824 589824 Veer, Nicholas de, of Macchyng 4
4433232 2175147 2175147 defendant Tagel John   589824 589824 Tagel, John, of Macchyng 0
4433236 2175147 2175147 defendant Veer Nicholas de   589824 589824 Veer, Nicholas de, of Macchyng 4
4439941 2181774 2181774 defendant Cool John   589824 589824 Cool, John, of Macchyng 0
4593418 2229227 2229227 defendant Shrub Robert   589824 589824 Shrub, Robert, of Macchyng 0
4603126 2232185 2232185 defendant Forster Reginald   589824 589824 Forster, Reginald, of Macchyng 1
4659367 2248789 2248789 defendant Martyn John laborer 589824 589824 Martyn, John, of Macchyng, laborer 3
4668339 2255813 2255813 defendant Lyndesle John husbandman 589824 589824 Lyndesle, John, of Macchyng, husbandman 1
4718728 2271197 2271197 plaintiff Clerk Thomas   589824 589824 Clerk, Thomas, of Macchyng, vicar 1
4729583 2274467 2274467 defendant Coteler John   589824 589824 Coteler, John, of Macchyng, hog heler 0
4729667 2274489 2274489 defendant Coteler John   589824 589824 Coteler, John, of Macchyng, "hogheler" 0
4775502 2288332 2288332 defendant Doweshed Robert carpenter 589824 589824 Doweshed, Robert, of Macchyng, carpenter 2
4775503 2288332 2288332 defendant Clerk Robert husbandman 589824 589824 Clerk, Robert, of Macchyng, husbandman 3
4834509 2306802 2306802 defendant Sweleard John gent 589824 589824 Sweleard, John, of Macchyng, gent 0
5341856 2457648 2457648 defendant Wroo John   589824 589824 Wroo, John, of Macchyng, notary 0
5420133 2480939 2480939 defendant Glasyer Thomas husbandman 589824 589824 Glasyer, Thomas, of Macchyng, husbandman 0
5479776 2498963 2498963 defendant Colyn Thomas husbandman 589824 589824 Colyn, Thomas, of Macchyng, husbandman 0
5541067 2517329 2517329 defendant Pakman John smith 589824 589824 Pakman, John, of Macchyng, smith 0
5611201 2547232 2547232 defendant Northerne John   589824 589824 Northerne, John, of Macchyng, vicar 0

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