names

24 rows where place_id = 766494

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4528752 2209276 2209276 defendant Ludlawe John   766494 766494 Ludlawe, John, of Loughtburgh 0
4618695 2236857 2236857 plaintiff Hayteleye Henry   766494 766494 Hayteleye, Henry, of Loughtburgh 0
4620203 2237299 2237299 defendant Coryour John   766494 766494 Coryour, John, of Loughtburgh 0
4620204 2237299 2237299 defendant Kyrkeby John   766494 766494 Kyrkeby, John, of Loughtburgh 1
4629203 2240065 2240065 plaintiff Smyth John (legal representative) 766494 766494 Smyth, John, of Loughtburgh, executors of 0
4631274 2240677 2240677 defendant Ludlowe John   766494 766494 Ludlowe, John, of Loughtburgh 1
4633561 2241350 2241350 defendant Breteyne Simon   766494 766494 Breteyne, Simon, of Loughtburgh 0
4683514 2260446 2260446 plaintiff Pegge Thomas   766494 766494 Pegge, Thomas, of Loughtburgh 0
4706359 2267371 2267371 defendant Roper William   766494 766494 Roper, William, of Loughtburgh, rope maker 0
4706709 2267483 2267483 defendant Holme William husbandman 766494 766494 Holme, William, of Loughtburgh, husbandman 2
4717039 2270657 2270657 defendant Ernemonger John   766494 766494 Ernemonger, John, of Loughtburgh, spice seller 2
4720782 2271831 2271831 defendant Barker John merchant 766494 766494 Barker, John, of Loughtburgh, merchant 2
4721330 2272003 2272003 plaintiff Cartwryght John   766494 766494 Cartwryght, John, of Loughtburgh 0
4724458 2272944 2272944 plaintiff Ewekynston Thomas (legal representative) 766494 766494 Ewekynston, Thomas, of Loughtburgh, parson, executors of 0
4724463 2272944 2272944 defendant Grene Richard husbandman 766494 766494 Grene, Richard, of Loughtburgh, husbandman 0
4730373 2274699 2274699 defendant Holme William (legal representative) 766494 766494 Holme, William, of Loughtburgh, husbandman, executors of 1
4730374 2274699 2274699 defendant Marnham William husbandman 766494 766494 (Marnham, William, of Loughtburgh, husbandman 2
4765924 2285338 2285338 defendant Ludlowe John tanner 766494 766494 Ludlowe, John, of Loughtburgh, tanner 0
4780568 2289918 2289918 plaintiff Burton William   766494 766494 Burton, William, of Loughtburgh 0
4784302 2291089 2291089 plaintiff Derby John woolman 766494 766494 Derby, John, of Loughtburgh, woolman 0
4784305 2291090 2291090 plaintiff Derby John   766494 766494 Derby, John, of Loughtburgh 0
4843309 2309424 2309424 plaintiff Marchall Richard   766494 766494 Marchall, Richard, of Loughtburgh 0
5303839 2446145 2446145 defendant Rydnges John yeoman 766494 766494 Rydnges, John, of Loughtburgh, yeoman 0
5459427 2492732 2492732 defendant Cas_ Robert yeoman 766494 766494 Cas_, Robert, of Loughtburgh, 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);