names

26 rows where place_id = 599520

✎ 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
3637122 1906409 1906409 defendant Tyrol James husbandman 599520 599520 Tyrol, James, of Asperton, husbandman 1
3683798 1921068 1921068 defendant Mayowe William weaver 599520 599520 Mayowe, William, of Asperton, weaver 0
3683802 1921069 1921069 defendant Meyowe William weaver 599520 599520 Meyowe, William, of Asperton, weaver 0
3771104 1948652 1948652 defendant Powes William husbandman 599520 599520 Powes, William, of Asperton, husbandman 3
3798683 1957500 1957500 defendant Agodishalall James husbandman 599520 599520 Agodishalall, James, of Asperton, husbandman 0
3798685 1957500 1957500 defendant Walker Thomas laborer 599520 599520 Walker, Thomas, of Asperton, laborer 2
3802637 1958720 1958720 defendant Harser John yeoman 599520 599520 Harser, John, of Asperton, yeoman 1
3839302 1970219 1970219 defendant Jaunsey James yeoman 599520 599520 Jaunsey, James, of Asperton, yeoman 4
4023223 2033015 2033015 defendant Walker Thomas yeoman 599520 599520 Walker, Thomas, of Asperton, yeoman 1
4055315 2044300 2044300 defendant Walker Thomas tailor 599520 599520 Walker, Thomas, of Asperton, tailor 1
4058951 2045596 2045596 defendant Tompkyns James yeoman 599520 599520 Tompkyns, James, of Asperton, yeoman 1
4061746 2046602 2046602 defendant Bagard George gent 599520 599520 Bagard, George, of Asperton, gent 0
4379467 2157738 2157738 defendant Browne Elizabeth widow 599520 599520 Browne, Elizabeth, of Asperton, widow 1
4386654 2160212 2160212 defendant Godsall James yeoman 599520 599520 Godsall, James, of Asperton, yeoman 1
4425277 2172733 2172733 defendant Broun John   599520 599520 Broun, John, of Asperton 0
4513282 2204571 2204571 defendant Stroyte John clerk 599520 599520 Stroyte, John, of Asperton, clerk 3
4517783 2205956 2205956 defendant Streyt William   599520 599520 Streyt, William, of Asperton 0
4517784 2205956 2205956 defendant Fychet Richard   599520 599520 Fychet, Richard, of Asperton 1
4602861 2232110 2232110 plaintiff Bron John   599520 599520 Bron, John, of Asperton 3
4641128 2243496 2243496 defendant Bole John   599520 599520 Bole, John, of Asperton 1
4685098 2260940 2260940 defendant Bole John chapman 599520 599520 Bole, John, of Asperton, chapman 1
4695569 2264098 2264098 defendant Comyn Henry gent 599520 599520 Comyn, Henry, of Asperton, gent 1
4893852 2324775 2324775 defendant Maynston Geoffrey husbandman 599520 599520 Maynston, Geoffrey, of Asperton, husbandman 2
5333848 2455194 2455194 defendant Billesford Thomas husbandman 599520 599520 Billesford, Thomas, of Asperton, husbandman 0
5525295 2512504 2512504 defendant Tyrald John husbandman 599520 599520 Tyrald, John, of Asperton, husbandman 3
5525296 2512504 2512504 defendant Tyralde William husbandman 599520 599520 Tyralde, William, of Asperton, husbandman 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);