names

31 rows where place_id = 590504

✎ 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
3601407 1868100 1868100 defendant Hungre John clerk 590504 590504 Hungre, John, of Billyngford, clerk 1
3659075 1913101 1913101 defendant Fesaunt William husbandman 590504 590504 Fesaunt, William, of senior, Billyngford, husbandman 3
3714504 1930833 1930833 defendant Feltwell Robert husbandman 590504 590504 Feltwell, Robert, of Billyngford, husbandman 0
3714505 1930833 1930833 defendant Feltwell John husbandman 590504 590504 Feltwell, John, of Billyngford, husbandman 1
3844110 1971706 1971706 defendant Dorman Patrick husbandman 590504 590504 Dorman, Patrick, of Billyngford, husbandman 3
4433934 2175374 2175374 plaintiff Hedersete Roger de master & parson 590504 590504 Hedersete, Roger de, of Billyngford, master & parson 0
4433936 2175374 2175374 defendant Lomb William   590504 590504 Lomb, William, of Billyngford 1
4440089 2181826 2181826 defendant Cursen William   590504 590504 Cursen, William, of billyngford 1
4685447 2261045 2261045 defendant Weybrigge Hugh yeoman 590504 590504 Weybrigge, Hugh, of Billyngford, yeoman 0
4748212 2279983 2279983 defendant Reed Richard yeoman 590504 590504 Reed, Richard, of Billyngford, yeoman 3
4750120 2280508 2280508 defendant Kenge Thomas husbandman 590504 590504 Kenge, Thomas, of Billyngford, husbandman 2
4860985 2314795 2314795 defendant Horne Andrew husbandman 590504 590504 Horne, Andrew, of Billyngford, husbandman 1
4981410 2351357 2351357 defendant Rose Robert laborer 590504 590504 Rose, Robert, of Billyngford, laborer 0
4981411 2351357 2351357 defendant Gymere or Eymere Robert laborer 590504 590504 Gymere or Eymere, Robert, of Billyngford, laborer 1
5058339 2374039 2374039 defendant Broune Henry tailor 590504 590504 Broune, Henry, of Billyngford, tailor 0
5058340 2374039 2374039 defendant Broune John tailor 590504 590504 Broune, John, of Billyngford, tailor 1
5058341 2374039 2374039 defendant Rose Robert tailor 590504 590504 Rose, Robert, of Billyngford, tailor 2
5059082 2374281 2374281 defendant Broun Henry tailor 590504 590504 Broun, Henry, of Billyngford, tailor 0
5074775 2378960 2378960 defendant Waryn John husbandman 590504 590504 Waryn, John, of Billyngford, husbandman 1
5094860 2384912 2384912 defendant Thurston Robert husbandman 590504 590504 Thurston, Robert, of Billyngford, husbandman 0
5107035 2388488 2388488 defendant Curson William gent 590504 590504 together with Curson, William, of Billyngford, gent 1
5146261 2400036 2400036 defendant Lyncoln William yeoman 590504 590504 Lyncoln, William, of Billyngford, yeoman 1
5165435 2405635 2405635 defendant Lyncoln William yeoman 590504 590504 Lyncoln, William, of Billyngford, yeoman 1
5168920 2406639 2406639 defendant Thurstone Robert husbandman 590504 590504 Thurstone, Robert, of Billyngford, husbandman 0
5181272 2410265 2410265 defendant Lincoln William yeoman 590504 590504 Lincoln, William, of Billyngford, yeoman 1
5184139 2411099 2411099 defendant Lyng Thomas   590504 590504 Lyng, Thomas, of Billyngford, gent, administrators of 3
5185175 2411410 2411410 defendant Thurstone Robert husbandman 590504 590504 Thurstone, Robert, of Billyngford, husbandman 0
5204175 2416976 2416976 defendant Lyng Thomas   590504 590504 Lyng, Thomas, of Billyngford, gent, administrators of 0
5204674 2417112 2417112 defendant Thurstone Robert husbandman 590504 590504 Thurstone, Robert, of Billyngford, husbandman 0
5249021 2429836 2429836 defendant Ludham Hugh husbandman 590504 590504 Ludham, Hugh, of Billyngford, husbandman 4
5480613 2499167 2499167 defendant Crome John yeoman 590504 590504 Crome, John, of Billyngford, yeoman 9

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