names

30 rows where place_id = 637452

✎ 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
3815678 1962821 1962821 defendant Collys Thomas   637452 637452 Collys, Thomas, of Clay juxta Mare, freemason 0
3836609 1969352 1969352 defendant Symond Ralph   637452 637452 Symond, Ralph, of Clay juxta Mare 0
3860515 1977009 1977009 defendant Miller William husbandman 637452 637452 Miller, William, of Clay juxta Mare, husbandman 2
3945652 2005554 2005554 defendant Emmys Christopher merchant 637452 637452 Emmys, Christopher, of Clay juxta Mare, merchant 0
3956205 2009241 2009241 defendant Alyson James merchant 637452 637452 Alyson, James, of Clay juxta Mare, merchant 4
3974696 2015718 2015718 defendant Dowell John mariner 637452 637452 Dowell, John, of Clay juxta Mare, mariner 0
4060857 2046289 2046289 defendant Dowell John carpenter 637452 637452 Dowell, John, of Clay juxta Mare, carpenter 0
4063253 2047152 2047152 defendant Freman Geoffrey yeoman 637452 637452 Freman, Geoffrey, of Clay juxta Mare, yeoman 0
4066862 2048445 2048445 defendant Newport Richard mariner 637452 637452 Newport, Richard, of Clay juxta Mare, mariner 0
4071813 2050217 2050217 defendant Underwood John gent 637452 637452 Underwood, John, of Clay juxta Mare, gent 1
4071816 2050218 2050218 defendant Underwoode John gent 637452 637452 Underwoode, John, of Clay juxta Mare, gent 1
4074979 2051353 2051353 defendant Letle Robert (legal representative) 637452 637452 Letle, Robert, of Clay juxta Mare, merchant, administratrix of 0
4094895 2058505 2058505 defendant Sutton Nicholas   637452 637452 Sutton, Nicholas, of Clay juxta Mare, rope maker 1
4110751 2064104 2064104 defendant Aldrytche Robert merchant 637452 637452 Aldrytche, Robert, of Clay juxta Mare, or of Great Yarmouth, merchant 0
4144662 2076291 2076291 defendant Dowell Robert husbandman 637452 637452 Dowell, Robert, of Clay juxta Mare, husbandman 1
4195690 2094047 2094047 defendant Wulston John merchant 637452 637452 Wulston, John, of Clay juxta Mare, merchant 2
4214014 2100422 2100422 defendant Sutton William   637452 637452 Sutton, William, of Clay juxta Mare, rope maker 0
4214015 2100422 2100422 defendant Sutton John   637452 637452 Sutton, John, of Clay juxta Mare, rope maker 1
4216437 2101243 2101243 defendant Baxter Nicholas yeoman 637452 637452 Baxter, Nicholas, of Clay juxta Mare, yeoman 3
4218735 2102055 2102055 defendant Newgate Christopher merchant 637452 637452 Newgate, Christopher, of Clay juxta Mare, merchant 2
4220457 2102658 2102658 defendant Jepps Thomas mariner 637452 637452 Jepps, Thomas, of Clay juxta Mare, mariner 0
4220458 2102658 2102658 defendant Pounser Francis mariner 637452 637452 Pounser, Francis, of Clay juxta mare, mariner 1
4248383 2112449 2112449 defendant Chambers William mariner 637452 637452 Chambers, William, of Clay juxta Mare, mariner 0
4252088 2113689 2113689 defendant Pawe Peter mariner 637452 637452 Pawe, Peter, of Clay juxta Mare, mariner 0
4277241 2121972 2121972 defendant Baxter Nicholas yeoman 637452 637452 Baxter, Nicholas, of Clay juxta Mare, yeoman 0
4403201 2165641 2165641 defendant Hunt Richard   637452 637452 Hunt, Richard, of Clay juxta Mare, shepherd 1
5277920 2438631 2438631 defendant Brygge John gent 637452 637452 Brygge, John, of Clay juxta Mare, gent 0
5283335 2440184 2440184 defendant Brygge John gent 637452 637452 Brygge, John, of Clay juxta Mare, gent 0
5359234 2462927 2462927 defendant Laurence Robert yeoman 637452 637452 Laurence, Robert, of Clay juxta Mare, yeoman 0
5545541 2518684 2518684 defendant Gley or Eley John yeoman 637452 637452 Gley or Eley, John, of Clay juxta Mare, yeoman 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);