names

19 rows where place_id = 587424

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591373 1864926 1864926 defendant Fabyan John husbandman 587424 587424 Fabyan, John, of Exnyng, Suff, husbandman 0
3756036 1943843 1943843 defendant Dawberi John laborer 587424 587424 Dawberi, John, of Exnyng, Suff, laborer 1
3763045 1946073 1946073 defendant Mott Robert husbandman 587424 587424 Mott, Robert, of Exnyng, Suff, husbandman 0
3773713 1949495 1949495 defendant Dawbrey John laborer 587424 587424 Dawbrey, John, of Exnyng, Suff, laborer 1
3803382 1958959 1958959 defendant Grave John smith 587424 587424 Grave, John, of Exnyng, Suff, smith 2
3866839 1979143 1979143 plaintiff Fabyan John husbandman 587424 587424 Fabyan, John, of Exnyng, Suff, husbandman 2
3881520 1984081 1984081 defendant Fabyan Thomas   587424 587424 Fabyan, Thomas, of Exnyng, Suff, horse leach 1
3914970 1995358 1995358 defendant Parker William husbandman 587424 587424 Parker, William, of Exnyng, Suff, husbandman 0
4769583 2286464 2286464 defendant Cook Thomas husbandman 587424 587424 Cook, Thomas, of Exnyng, Suff, husbandman 4
4829352 2305220 2305220 defendant Bele William husbandman 587424 587424 Bele, William, of Exnyng, Suff, husbandman 0
4856151 2313294 2313294 defendant Bele William husbandman 587424 587424 Bele, William, of Exnyng, Suff, husbandman 0
4903419 2327676 2327676 defendant Gardener John yeoman 587424 587424 Gardener, John, of Exnyng, Suff, yeoman 0
4953235 2342927 2342927 defendant Tredegold Henry yeoman 587424 587424 Tredegold, Henry, of Exnyng, Suff, yeoman 0
4956395 2343876 2343876 defendant Caldewell John clerk 587424 587424 Caldewell, John, of Exnyng, Suff, clerk 4
5007399 2359057 2359057 defendant Coterell Nicholas yeoman 587424 587424 Coterell, Nicholas, of Exnyng, Suff, yeoman 0
5007401 2359058 2359058 defendant Coterell Nicholas yeoman 587424 587424 Coterell, Nicholas, of Exnyng, Suff, yeoman 0
5033728 2366743 2366743 defendant Coterell Nicholas yeoman 587424 587424 Coterell, Nicholas, of Exnyng, Suff, yeoman 0
5049004 2371338 2371338 defendant Tredegold Henry yeoman 587424 587424 Tredegold, Henry, of Exnyng, Suff, yeoman 1
5049010 2371339 2371339 defendant Tredegold Henry yoeman 587424 587424 Tredegold, Henry, of Exnyng, Suff, yoeman 1

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