names

34 rows where place_id = 608386

✎ 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
3673497 1917736 1917736 defendant Clerke Thomas husbandman 608386 608386 Clerke, Thomas, of Todyngdon, husbandman 0
3673499 1917736 1917736 defendant Walley Richard miller 608386 608386 Walley, Richard, of Todyngdon, miller 2
4632476 2241047 2241047 defendant Ive Thomas   608386 608386 Ive, Thomas, of Todyngdon 2
4732807 2275438 2275438 plaintiff Peynere Thomas   608386 608386 Peynere, Thomas, of Todyngdon 0
4822782 2303206 2303206 defendant Sanne William husbandman 608386 608386 Sanne, William, of Todyngdon, husbandman 0
4925914 2334535 2334535 defendant Felmersham John husbandman 608386 608386 Felmersham, John, of Todyngdon, husbandman 0
4925915 2334535 2334535 defendant Vale John husbandman 608386 608386 Vale, John, of Todyngdon, husbandman 1
5000738 2357091 2357091 defendant Hamond William laborer 608386 608386 Hamond, William, of Todyngdon, laborer 0
5026980 2364763 2364763 defendant Coleyn John husbandman 608386 608386 Coleyn, John, of Todyngdon, husbandman 0
5026981 2364763 2364763 defendant Felmersham John husbandman 608386 608386 Felmersham, John, of Todyngdon, husbandman 1
5082436 2381244 2381244 defendant Reve John husbandman 608386 608386 Reve, John, of Todyngdon, husbandman 0
5205221 2417285 2417285 plaintiff Grenefeld William   608386 608386 Grenefeld, William, of Todyngdon, warden of the hospital of St John Baptist 0
5240636 2427474 2427474 defendant Fuller William fuller 608386 608386 Fuller, William, of Todyngdon, fuller 1
5255541 2431849 2431849 defendant Marchall John, junior tailor 608386 608386 Marchall, John, junior, of Todyngdon, tailor 0
5342509 2457857 2457857 plaintiff Scarlet Ralph   608386 608386 Scarlet, Ralph, of Todyngdon 0
5348539 2459679 2459679 defendant Mathewe Robert butcher 608386 608386 Mathewe, Robert, of Todyngdon, butcher 0
5348552 2459682 2459682 defendant Wymond John chapman 608386 608386 Wymond, John, of Todyngdon, chapman 2
5348562 2459684 2459684 defendant Rugmer John baker 608386 608386 Rugmer, John, of Todyngdon, baker 3
5352543 2460889 2460889 defendant Mathewe Robert butcher 608386 608386 Mathewe, Robert, of Todyngdon, butcher 0
5352544 2460889 2460889 defendant Wymond John mercer 608386 608386 Wymond, John, of Todyngdon, mercer 1
5352546 2460890 2460890 defendant Mathewe Robert butcher 608386 608386 Mathewe, Robert, of Todyngdon, butcher 0
5352547 2460890 2460890 defendant Wymond John mercer 608386 608386 Wymond, John, of Todyngdon, mercer 1
5363905 2464362 2464362 defendant Rede Robert husbandman 608386 608386 Rede, Robert, of Todyngdon, husbandman 0
5366388 2465138 2465138 plaintiff Broughton John   608386 608386 Broughton, John, of Todyngdon 0
5385012 2470790 2470790 plaintiff Broughton John   608386 608386 Broughton, John, of Todyngdon 0
5396919 2474201 2474201 defendant Broughton John   608386 608386 Broughton, John, of Todyngdon 0
5397064 2474245 2474245 plaintiff Broughton John   608386 608386 Broughton, John, of Todyngdon 0
5419868 2480856 2480856 defendant Broun John fisher 608386 608386 Broun, John, of Todyngdon, fisher 0
5491030 2502215 2502215 defendant Tylcok Thomas husbandman 608386 608386 Tylcok, Thomas, of Todyngdon, husbandman 1
5491031 2502215 2502215 defendant Pulter Thomas husbandman 608386 608386 Pulter, Thomas, of Todyngdon, husbandman 2
5491037 2502216 2502216 defendant Tylcok Thomas husbandman 608386 608386 Tylcok, Thomas, of Todyngdon, husbandman 1
5491038 2502216 2502216 defendant Pulter Thomas husbandman 608386 608386 Pulter, Thomas, of Todyngdon, husbandman 2
5496564 2503885 2503885 defendant Scarlet Ralph (legal representative) 608386 608386 Scarlet, Ralph, of Todyngdon, yeoman, administratrix of 3
5496565 2503885 2503885 defendant Scarlet Margaret widow 608386 608386 Scarlet, Margaret, of Todyngdon, widow 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);