names

28 rows where place_id = 589032

✎ 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
3596324 1866479 1866479 defendant Wodeward John laborer 589032 589032 Wodeward, John, of White Notley, laborer 1
3604415 1869048 1869048 defendant Bate John miller 589032 589032 Bate, John, of White Notley, miller 1
3677966 1919151 1919151 defendant Johnson alias Carpenter Richard husbandman 589032 589032 Johnson alias Carpenter, Richard, of White Notley, husbandman 0
3702648 1927096 1927096 defendant Elyse John husbandman 589032 589032 Elyse, John, of White Notley, husbandman 0
3735743 1937417 1937417 defendant Compley Thomas carpenter 589032 589032 Compley, Thomas, of White Notley, carpenter 0
3762504 1945915 1945915 defendant Ellys John laborer 589032 589032 Ellys, John, of White Notley, laborer 0
3805101 1959537 1959537 defendant Crakbone Thomas husbandman 589032 589032 Crakbone, Thomas, of White Notley, husbandman 0
3919217 1996755 1996755 defendant Frankey John husbandman 589032 589032 Frankey, John, of White Notley, husbandman 2
4711267 2268869 2268869 defendant Pulter John   589032 589032 Pulter, John, of White Notley, husb 4
4711271 2268869 2268869 defendant Sakkere John   589032 589032 Sakkere, John, of White Notley, husb 8
4711291 2268870 2268870 defendant Pulter John husbandman 589032 589032 Pulter, John, of White Notley, husbandman 4
4711295 2268870 2268870 defendant Saklere John husbandman 589032 589032 Saklere, John, of White Notley, husbandman 8
4711314 2268871 2268871 defendant Pulter John husbandman 589032 589032 Pulter, John, of White Notley, husbandman 3
4711318 2268871 2268871 defendant Saklere John husbandman 589032 589032 Saklere, John, of White Notley, husbandman 7
4734949 2276085 2276085 defendant Sakkere John husbandman 589032 589032 Sakkere, John, of White Notley, husbandman 4
4867152 2316687 2316687 defendant Dallyngton Thomas clerk 589032 589032 Dallyngton, Thomas, of White Notley, clerk 0
5086399 2382418 2382418 plaintiff Herde Thomas   589032 589032 Herde, Thomas, of White Notley 0
5086400 2382418 2382418 defendant Coumbys Thomas husbandman 589032 589032 Coumbys, Thomas, of White Notley, husbandman 0
5346583 2459081 2459081 defendant Assh Thomas tailor 589032 589032 Assh, Thomas, of White Notley, tailor 1
5369771 2466135 2466135 defendant Elys Richard husbandman 589032 589032 Elys, Richard, of White Notley, husbandman 1
5369772 2466135 2466135 defendant Assy Thomas husbandman 589032 589032 Assy, Thomas, of White Notley, husbandman 2
5425449 2482586 2482586 defendant Whytyng John husbandman 589032 589032 Whytyng, John, of White Notley, husbandman 1
5443924 2488099 2488099 defendant Whytyng John husbandman 589032 589032 Whytyng, John, of White Notley, husbandman 0
5456674 2491919 2491919 defendant Whytyng John husbandman 589032 589032 Whytyng, John, of White Notley, husbandman 0
5456676 2491920 2491920 defendant Whytyng John husbandman 589032 589032 Whytyng, John, of White Notley, husbandman 0
5558868 2522544 2522544 defendant Hede John, junior husbandman 589032 589032 Hede, John, junior, of White Notley, husbandman 0
5622955 2551116 2551116 defendant Russel Simon   589032 589032 Russel, Simon, of White Notley 1
5622957 2551117 2551117 defendant Wodeward John   589032 589032 Wodeward, John, of White Notley 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);