names

29 rows where place_id = 642067

✎ 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
3865606 1978713 1978713 defendant Parsons Thomas husbandman 642067 642067 Parsons, Thomas, of Edyngley, husbandman 0
3972089 2014798 2014798 defendant Anger Richard husbandman 642067 642067 Anger, Richard, of Edyngley, husbandman 0
3972090 2014798 2014798 defendant Mylney Robert husbandman 642067 642067 Mylney, Robert, of Edyngley, husbandman 1
3972091 2014798 2014798 defendant Mylney Ralph husbandman 642067 642067 Mylney, Ralph, of Edyngley, husbandman 2
3972092 2014798 2014798 defendant Smyth John laborer 642067 642067 Smyth, John, of Edyngley, laborer 3
4422258 2171830 2171830 defendant Thurgerton Richard   642067 642067 Thurgerton, Richard, of Edyngley 0
4530685 2209890 2209890 defendant Richardson Thomas   642067 642067 Richardson, Thomas, of Edyngley 1
4530686 2209890 2209890 defendant Angene John   642067 642067 Angene, John, of Edyngley 2
4530687 2209890 2209890 defendant Page William   642067 642067 Page, William, of Edyngley 3
4624191 2238548 2238548 defendant Falk John   642067 642067 Falk, John, of Edyngley 0
4660353 2249068 2249068 defendant More John smith 642067 642067 More, John, of Edyngley, smith 2
4670992 2256597 2256597 defendant Dyconson William husbandman 642067 642067 Dyconson, William, of Edyngley, husbandman 1
4698207 2264925 2264925 defendant Angene John husbandman 642067 642067 Angene, John, of Edyngley, husbandman 0
4713565 2269563 2269563 defendant Augene John husbandman 642067 642067 Augene, John, of Edyngley, husbandman 0
4732245 2275264 2275264 defendant Coy Robert husbandman 642067 642067 Coy, Robert, of Edyngley, husbandman 2
4732246 2275264 2275264 defendant Angene John husbandman 642067 642067 Angene, John, of Edyngley, husbandman 3
4754825 2281889 2281889 defendant Rygmayden William esq 642067 642067 Rygmayden, William, of Edyngley, esq 0
4800898 2296467 2296467 defendant Whippe William husbandman 642067 642067 Whippe, William, of Edyngley, husbandman 3
4868180 2317025 2317025 defendant Blytheworth Robert husbandman 642067 642067 Blytheworth, Robert, of Edyngley, husbandman 0
4872141 2318245 2318245 defendant Angene or Angeve John husbandman 642067 642067 Angene or Angeve, John, of Edyngley, husbandman 10
4936395 2337774 2337774 defendant Boweman Henry gent 642067 642067 Boweman, Henry, of Edyngley, gent 0
4964484 2346283 2346283 defendant Barry Ralph yeoman 642067 642067 Barry, Ralph, of Edyngley, yeoman 2
5227466 2423660 2423660 defendant Hamond Richard husbandman 642067 642067 Hamond, Richard, of Edyngley, husbandman 2
5231649 2424834 2424834 defendant Couper Walter husbandman 642067 642067 Couper, Walter, of Edyngley, husbandman 3
5246764 2429215 2429215 defendant Tomlynson John husbandman 642067 642067 Tomlynson, John, of Edyngley, husbandman 2
5338537 2456620 2456620 defendant Leeke Simon husbandman 642067 642067 Leeke, Simon, of Edyngley, husbandman 0
5348820 2459758 2459758 defendant Couper Walter husbandman 642067 642067 Couper, Walter, of Edyngley, husbandman 1
5513373 2509035 2509035 defendant Bothom John yeoman 642067 642067 Bothom, John, of Edyngley, yeoman 0
5611087 2547189 2547189 defendant Magson John   642067 642067 Magson, John, of Edyngley 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);