names

20 rows where place_id = 608716

✎ 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
3675080 1918239 1918239 plaintiff Halle Richard husbandman 608716 608716 Halle, Richard, of Over Norton, husbandman 0
3956703 2009411 2009411 defendant Hylton alias Luddyngton Thomas laborer 608716 608716 Hylton alias Luddyngton, Thomas, of Over Norton, laborer 0
4137510 2073766 2073766 defendant Walter William husbandman 608716 608716 Walter, William, of Over Norton, husbandman 0
4301442 2130620 2130620 defendant Busby William husbandman 608716 608716 Busby, William, of Over Norton, husbandman 1
4301443 2130620 2130620 defendant Hopkyns Edmund husbandman 608716 608716 Hopkyns, Edmund, of Over Norton, husbandman 2
4720033 2271613 2271613 defendant Frensh John husbandman 608716 608716 Frensh, John, of Over Norton, husbandman 1
4768509 2286125 2286125 defendant Cok William husbandman 608716 608716 Cok, William, of Over Norton, husbandman 0
4913693 2330781 2330781 defendant Edward William husbandman 608716 608716 Edward, William, of Over Norton, husbandman 0
5135128 2396772 2396772 defendant Ponyard or Pouyard John husbandman 608716 608716 Ponyard or Pouyard, John, of Over Norton, husbandman 0
5155223 2402675 2402675 defendant Clerkke William husbandman 608716 608716 Clerkke, William, of Over Norton, husbandman 1
5171942 2407507 2407507 defendant Clerkke William husbandman 608716 608716 Clerkke, William, of Over Norton, husbandman 1
5180446 2410024 2410024 defendant Clerke William husbandman 608716 608716 Clerke, William, of Over Norton, husbandman 2
5190718 2413035 2413035 defendant Clerkke William husbandman 608716 608716 Clerkke, William, of Over Norton, husbandman 1
5202426 2416473 2416473 defendant Clerke William husbandman 608716 608716 Clerke, William, of Over Norton, husbandman 2
5242012 2427865 2427865 defendant Clerke William husbandman 608716 608716 Clerke, William, of Over Norton, husbandman 1
5242015 2427866 2427866 defendant Clerke William husbandman 608716 608716 Clerke, William, of Over Norton, husbandman 1
5257934 2432604 2432604 defendant Balle Thomas husbandman 608716 608716 Balle, Thomas, of Over Norton, husbandman 0
5553958 2521198 2521198 defendant Bedyll John husbandman 608716 608716 Bedyll, John, of Over Norton, husbandman 0
5635055 2554950 2554950 defendant Penyhard Thomas ploughman 608716 608716 Penyhard, Thomas, of Over Norton, ploughman 3
5635056 2554950 2554950 defendant Chestre John shoemaker 608716 608716 Chestre, John, of Over Norton, shoemaker 4

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);