names

20 rows where place_id = 761744

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4471035 2191598 2191598 defendant Lanet John   761744 761744 Lanet, John, of Great Ryburgh, parson 0
4481481 2194902 2194902 defendant Tydyng William   761744 761744 Tydyng, William, of Great Ryburgh 1
4755256 2282032 2282032 defendant Pays John husbandman 761744 761744 Pays, John, of Great Ryburgh, husbandman 0
4816899 2301388 2301388 defendant Gardener Simon butcher 761744 761744 Gardener, Simon, of Great Ryburgh, butcher 4
4993020 2354798 2354798 defendant Willes John husbandman 761744 761744 Willes, John, of Great Ryburgh, husbandman 0
4995343 2355452 2355452 defendant Wylles John yeoman 761744 761744 Wylles, John, of Great Ryburgh, yeoman 0
5041598 2369089 2369089 defendant Wyllys John yeoman 761744 761744 Wyllys, John, of Great Ryburgh, yeoman 2
5046711 2370639 2370639 defendant atte Mille John miller 761744 761744 atte Mille, John, of Great Ryburgh, miller 1
5271667 2436811 2436811 defendant Nell John, junior husbandman 761744 761744 Nell, John, junior, of Great Ryburgh, husbandman 1
5275071 2437789 2437789 defendant Neell John husbandman 761744 761744 Neell, John, of Great Ryburgh, husbandman 1
5299088 2444715 2444715 defendant Prynce John butcher 761744 761744 Prynce, John, of Great Ryburgh, butcher 1
5304428 2446322 2446322 defendant Chaunceys William gent 761744 761744 Chaunceys, William, of Great Ryburgh, gent 2
5366826 2465279 2465279 defendant Palmer Thomas clerk 761744 761744 Palmer, Thomas, of Great Ryburgh, clerk 0
5389281 2471978 2471978 defendant Neell John husbandman 761744 761744 Neell, John, of Great Ryburgh, husbandman 5
5401937 2475614 2475614 defendant Neell John husbandman 761744 761744 Neell, John, of Great Ryburgh, husbandman 5
5410015 2477961 2477961 defendant Neell Nicholas husbandman 761744 761744 Neell, Nicholas, of Great Ryburgh, husbandman 0
5414852 2479374 2479374 defendant (illegible) John husbandman 761744 761744 _, John, of Great Ryburgh, husbandman 5
5416615 2479884 2479884 defendant Couper John husbandman 761744 761744 Couper, John, of Great Ryburgh, husbandman 1
5426760 2482947 2482947 defendant Wethy Henry husbandman 761744 761744 Wethy, Henry, of Great Ryburgh, husbandman 4
5449285 2489677 2489677 defendant Couper John husbandman 761744 761744 Couper, John, of Great Ryburgh, husbandman 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);