names

25 rows where place_id = 616692

✎ 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
3715657 1931187 1931187 defendant Wreke John husbandman 616692 616692 Wreke, John, of Cattesfeld, husbandman 0
4580183 2225290 2225290 defendant Loufford John   616692 616692 Loufford, John, of Cattesfeld 0
4596663 2230192 2230192 defendant atte Hope Thomas   616692 616692 atte Hope, Thomas, of Cattesfeld 3
4692788 2263257 2263257 defendant atte Hope Nicholas hunter 616692 616692 atte Hope, Nicholas, of Cattesfeld, hunter 0
4704772 2266870 2266870 defendant atte Broke John husbandman 616692 616692 atte Broke, John, of Cattesfeld, husbandman 0
4710120 2268518 2268518 defendant Watte John husbandman 616692 616692 Watte, John, of Cattesfeld, husbandman 3
4755011 2281951 2281951 defendant Manefyn John gent 616692 616692 Manefyn, John, of Cattesfeld, gent 0
4757074 2282582 2282582 defendant atte Hope Nicholas   616692 616692 atte Hope, Nicholas, of Cattesfeld, bailiff 0
4810208 2299338 2299338 defendant Mavesyn John husbandman 616692 616692 Mavesyn, John, of Cattesfeld, husbandman 0
4810210 2299339 2299339 defendant Mavesyn John   616692 616692 Mavesyn, John, of Cattesfeld, franklin 0
4828550 2304968 2304968 defendant atte Hope Nicholas   616692 616692 atte Hope, Nicholas, of Cattesfeld, bailiff 1
4828553 2304968 2304968 defendant atte Hope John husbandman 616692 616692 atte Hope, John, of Cattesfeld, husbandman 4
4906536 2328630 2328630 defendant Middelton Nicholas clerk 616692 616692 Middelton, Nicholas, of Cattesfeld, clerk 0
4929915 2335768 2335768 defendant Yellyng John husbandman 616692 616692 Yellyng, John, of Cattesfeld, husbandman 0
4933590 2336888 2336888 defendant Frensh Thomas weaver 616692 616692 Frensh, Thomas, of Cattesfeld, weaver 1
4934202 2337085 2337085 defendant Frensh Thomas weaver 616692 616692 Frensh, Thomas, of Cattesfeld, weaver 1
4942049 2339495 2339495 defendant Turpyn Richard husbandman 616692 616692 Turpyn, Richard, of Cattesfeld, husbandman 0
4955451 2343591 2343591 defendant Yellyng John husbandman 616692 616692 Yellyng, John, of Cattesfeld, husbandman 0
4963497 2345995 2345995 defendant Peryman John husbandman 616692 616692 Peryman, John, of Cattesfeld, husbandman 0
4972768 2348791 2348791 defendant Middelton Nicholas clerk 616692 616692 Middelton, Nicholas, of Cattesfeld, clerk 0
5008604 2359410 2359410 defendant Yellyng John gent 616692 616692 Yellyng, John, of Cattesfeld, gent 0
5028144 2365103 2365103 defendant Maveson or Maueson John gent 616692 616692 Maveson or Maueson, John, of Cattesfeld, gent 0
5256785 2432246 2432246 defendant Mauefyn John gent 616692 616692 Mauefyn, John, of Cattesfeld, gent 0
5270582 2436492 2436492 defendant Mavesyn John gent 616692 616692 Mavesyn, John, of Cattesfeld, gent 0
5376062 2468105 2468105 defendant Plumsted Robert smith 616692 616692 Plumsted, Robert, of Cattesfeld, smith 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);