names

16 rows where place_id = 609737

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680050 1919823 1919823 defendant Shulder William husbandman 609737 609737 Shulder, William, of Wyvelesfeld, husbandman 0
3766420 1947154 1947154 defendant Thurstone Walter tailor 609737 609737 Thurstone, Walter, of Wyvelesfeld, tailor 0
3766421 1947154 1947154 defendant Kydde Robert tanner 609737 609737 Kydde, Robert, of Wyvelesfeld, tanner 1
4055981 2044519 2044519 defendant Atree John gent 609737 609737 Atree, John, of Wyvelesfeld, gent 0
4438400 2181301 2181301 defendant Genne Thomas   609737 609737 Genne, Thomas, of Wyvelesfeld 0
4444174 2183155 2183155 defendant Shulter Richard   609737 609737 Shulter, Richard, of Wyvelesfeld 1
4811289 2299640 2299640 defendant Pyltebem John husbandman 609737 609737 Pyltebem, John, of Wyvelesfeld, husbandman 1
4811290 2299640 2299640 defendant Boneld William husbandman 609737 609737 Boneld, William, of Wyvelesfeld, husbandman 2
4837680 2307717 2307717 defendant Pyltebem John husbandman 609737 609737 Pyltebem, John, of Wyvelesfeld, husbandman 1
4837681 2307717 2307717 defendant Goneld William husbandman 609737 609737 Goneld, William, of Wyvelesfeld, husbandman 2
4864908 2315999 2315999 defendant Pylteben John husbandman 609737 609737 Pylteben, John, of Wyvelesfeld, husbandman 1
4864909 2315999 2315999 defendant Gonald William husbandman 609737 609737 Gonald, William, of Wyvelesfeld, husbandman 2
5260618 2433452 2433452 defendant Atherstede John tanner 609737 609737 Atherstede, John, of Wyvelesfeld, tanner 9
5260621 2433452 2433452 defendant Attre John laborer 609737 609737 Attre, John, of Wyvelesfeld, laborer 12
5337345 2456240 2456240 defendant Mascall John tanner 609737 609737 Mascall, John, of Wyvelesfeld, tanner 0
5626908 2552390 2552390 defendant Medewey John husbandman 609737 609737 Medewey, John, of Wyvelesfeld, husbandman 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);