names

25 rows where place_id = 588512

✎ 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
3594777 1865991 1865991 defendant Frysby John husbandman 588512 588512 Frysby, John, of Micham, husbandman 3
3607228 1869926 1869926 defendant Power Thomas carver 588512 588512 Power, Thomas, of Micham, carver 0
3607229 1869926 1869926 defendant Power Robert carver 588512 588512 Power, Robert, of Micham, carver 1
3659680 1913283 1913283 defendant Byrthat William husbandman 588512 588512 Byrthat, William, of Micham, husbandman 4
3836527 1969329 1969329 defendant Chilman Thomas husbandman 588512 588512 Chilman, Thomas, of Micham, husbandman 3
4127104 2069983 2069983 defendant Palmer John yeoman 588512 588512 Palmer, John, of Micham, yeoman 0
4127106 2069983 2069983 defendant Hodge John, junior yeoman 588512 588512 Hodge, John, junior, of Micham, yeoman 2
4127107 2069983 2069983 defendant Philipps John shoemaker 588512 588512 Philipps, John, of Micham, shoemaker 3
4230580 2106192 2106192 defendant Whitney Henry   588512 588512 Whitney, Henry, of Micham, esq, adminstrator of 0
4460711 2188408 2188408 defendant Combe John   588512 588512 Combe, John, of Micham 1
4540219 2212843 2212843 plaintiff Webbe Peter   588512 588512 Webbe, Peter, of Micham 0
4562379 2219793 2219793 defendant Gavell William   588512 588512 Gavell, William, of Micham 0
4628705 2239902 2239902 plaintiff Otys William   588512 588512 Otys, William, of Micham 1
4770148 2286632 2286632 defendant Stere William laborer 588512 588512 Stere, William, of Micham, laborer 0
4821890 2302921 2302921 defendant Fresby Robert   588512 588512 Fresby, Robert, of Micham, parish clerk 0
5013385 2360750 2360750 defendant Est Robert husbandman 588512 588512 Est, Robert, of Micham, husbandman 2
5033746 2366750 2366750 plaintiff Spynulla Benedict (legal representative) 588512 588512 Spynulla, Benedict, of Micham, husbandman, executors of 0
5033748 2366750 2366750 plaintiff Spynulla Jerome husbandman 588512 588512 Spynulla, Jerome, of Micham, husbandman 2
5144499 2399551 2399551 defendant Stone Richard yeoman 588512 588512 Stone, Richard, of Micham, yeoman 2
5202242 2416419 2416419 defendant Palmere John husbandman 588512 588512 Palmere, John, of Micham, husbandman 2
5331573 2454520 2454520 defendant Leget John husbandman 588512 588512 Leget, John, of Micham, husbandman 0
5355301 2461731 2461731 defendant Yonge William husbandman 588512 588512 Yonge, William, of Micham, husbandman 0
5443315 2487918 2487918 defendant Waker John husbandman 588512 588512 Waker, John, of Micham, husbandman 0
5460068 2492941 2492941 defendant Fedylton John tailor 588512 588512 Fedylton, John, of Micham, tailor 0
5471718 2496491 2496491 defendant Fedylton John tailor 588512 588512 Fedylton, John, of Micham, tailor 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);