names

30 rows where place_id = 625090

✎ 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
3762013 1945765 1945765 defendant Haryson William husbandman 625090 625090 Haryson, William, of Skarnyng, husbandman 0
3768130 1947669 1947669 defendant Aunger William husbandman 625090 625090 Aunger, William, of Skarnyng, husbandman 0
3862689 1977715 1977715 defendant Johnson John butcher 625090 625090 Johnson, John, of Skarnyng, butcher 2
3862690 1977715 1977715 defendant Haryngton William husbandman 625090 625090 Haryngton, William, of Skarnyng, husbandman 3
3904167 1991638 1991638 defendant Johnson John butcher 625090 625090 Johnson, John, of Skarnyng, butcher 0
3904170 1991639 1991639 defendant Kyrby John husbandman 625090 625090 Kyrby, John, of Skarnyng, husbandman 0
3904171 1991639 1991639 defendant Skaye Richard husbandman 625090 625090 Skaye, Richard, of Skarnyng, husbandman 1
3910666 1993882 1993882 defendant Anger or Auger William (legal representative) 625090 625090 Anger or Auger, William, of Skarnyng, husbandman, executors of 3
3910667 1993882 1993882 defendant Cuttyng Thomas yeoman 625090 625090 (Cuttyng, Thomas, of Skarnyng, yeoman 4
3911321 1994103 1994103 defendant Skylhous George husbandman 625090 625090 Skylhous, George, of Skarnyng, husbandman 0
3912807 1994616 1994616 defendant Penton John husbandman 625090 625090 Penton, John, of Skarnyng, husbandman 0
3972166 2014827 2014827 defendant Benyngton Edmund husbandman 625090 625090 Benyngton, Edmund, of Skarnyng, husbandman 0
4013651 2029619 2029619 defendant Morgayne John   625090 625090 Morgayne, John, of Skarnyng, mason 2
4015207 2030130 2030130 defendant Banes John tanner 625090 625090 Banes, John, of Skarnyng, tanner 1
4025977 2033940 2033940 defendant Uttyng Thomas laborer 625090 625090 Uttyng, Thomas, of Skarnyng, laborer 1
4204453 2097104 2097104 defendant Mortymer Robert yeoman 625090 625090 Mortymer, Robert, of Skarnyng, yeoman 1
4220861 2102790 2102790 defendant Brodehurste Roger clerk 625090 625090 Brodehurste, Roger, of Skarnyng, clerk 0
4249544 2112833 2112833 defendant Marshall William husbandman 625090 625090 Marshall, William, of Skarnyng, husbandman 1
4257865 2115605 2115605 defendant Whynyard John plumber 625090 625090 Whynyard, John, of Skarnyng, plumber 2
4276459 2121709 2121709 defendant Coson Robert yeoman 625090 625090 Coson, Robert, of Skarnyng, yeoman 0
4335575 2142175 2142175 defendant Yates Henry carpenter 625090 625090 Yates, Henry, of Skarnyng, carpenter 2
4823828 2303533 2303533 defendant Waryn Thomas yeoman 625090 625090 Waryn, Thomas, of Skarnyng, yeoman 1
4979640 2350866 2350866 defendant Basse Thomas husbandman 625090 625090 Basse, Thomas, of Skarnyng, husbandman 0
5031605 2366108 2366108 defendant Tabbe Richard husbandman 625090 625090 Tabbe, Richard, of Skarnyng, husbandman 0
5031606 2366108 2366108 defendant Watlysden John husbandman 625090 625090 Watlysden, John, of Skarnyng, husbandman 1
5031607 2366108 2366108 defendant Crowe Simon husbandman 625090 625090 Crowe, Simon, of Skarnyng, husbandman 2
5275321 2437855 2437855 defendant Man Henry yeoman 625090 625090 Man, Henry, of Skarnyng, yeoman 1
5312275 2448708 2448708 defendant Tutte Mathew husbandman 625090 625090 Tutte, Mathew, of Skarnyng, husbandman 0
5317454 2450306 2450306 defendant Beld William husbandman 625090 625090 Beld, William, of Skarnyng, husbandman 0
5380870 2469584 2469584 defendant Toly Nicholas husbandman 625090 625090 Toly, Nicholas, of Skarnyng, husbandman 2

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