names

41 rows where place_id = 607720

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670564 1916756 1916756 defendant Bedall Edmund yeoman 607720 607720 Bedall, Edmund, of Cathorp, yeoman 2
3717433 1931736 1931736 defendant Thornton Thomas clerk 607720 607720 Thornton, Thomas, of Cathorp, clerk 0
3735171 1937234 1937234 defendant Kyrkby Thomas yeoman 607720 607720 Kyrkby, Thomas, of Cathorp, yeoman 3
3799925 1957893 1957893 plaintiff Kyrkby Thomas husbandman 607720 607720 Kyrkby, Thomas, of Cathorp, husbandman 0
3817350 1963337 1963337 plaintiff Kyrkby Thomas (legal representative) 607720 607720 Kyrkby, Thomas, of Cathorp, husbandman, executors of 0
4496015 2199429 2199429 defendant Wyles John   607720 607720 Wyles, John, of Cathorp 3
4501258 2200998 2200998 defendant Cheynell Robert   607720 607720 Cheynell, Robert, of Cathorp, parson 3
4531614 2210153 2210153 defendant Warde Robert   607720 607720 Warde, Robert, of Cathorp 8
4531627 2210154 2210154 defendant Warde Robert   607720 607720 Warde, Robert, of Cathorp 8
4561750 2219608 2219608 defendant Warde Robert   607720 607720 Warde, Robert, of Cathorp 8
4590591 2228415 2228415 defendant Huet William   607720 607720 Huet, William, of Cathorp 2
4683427 2260418 2260418 defendant Thorp Nicholas chaplain 607720 607720 Thorp, Nicholas, of Cathorp, chaplain 0
4801788 2296741 2296741 defendant Somour John butcher 607720 607720 Somour, John, of Cathorp, butcher 2
4809604 2299167 2299167 defendant atte Vycars Robert   607720 607720 atte Vycars, Robert, of Cathorp, parson 3
4875524 2319299 2319299 defendant Sharman Roger yeoman 607720 607720 Sharman, Roger, of Cathorp, yeoman 0
4875525 2319299 2319299 defendant Kylpecke Richard husbandman 607720 607720 Kylpecke, Richard, of Cathorp, husbandman 1
4881742 2321186 2321186 defendant Frere Thomas husbandman 607720 607720 Frere, Thomas, of Cathorp, husbandman 2
4911051 2329968 2329968 plaintiff Burgh John   607720 607720 Burgh, John, of Cathorp 2
4914885 2331166 2331166 plaintiff Burgh John   607720 607720 Burgh, John, of Cathorp 2
4914888 2331166 2331166 defendant Burgh John   607720 607720 Burgh, John, of Cathorp 2
4988536 2353528 2353528 plaintiff Burgh John   607720 607720 (Burgh, John, of Cathorp 1
4988541 2353529 2353529 plaintiff Burgh John   607720 607720 (Burgh, John, of Cathorp 1
4989384 2353760 2353760 plaintiff Burgh John   607720 607720 Burgh, John, of Cathorp 0
5015014 2361272 2361272 defendant Inglyssh John   607720 607720 Inglyssh, John, of Cathorp 0
5015684 2361473 2361473 plaintiff Burgh John   607720 607720 (Burgh, John, of Cathorp 1
5027254 2364843 2364843 defendant Grene Robert   607720 607720 Grene, Robert, of Cathorp, servant 0
5027255 2364843 2364843 defendant Wright John   607720 607720 Wright, John, of Cathorp, servant 1
5027256 2364843 2364843 defendant Handon Thomas husbandman 607720 607720 Handon, Thomas, of Cathorp, husbandman 2
5075873 2379276 2379276 defendant Tysynges John yeoman 607720 607720 Tysynges, John, of Cathorp, yeoman 0
5075877 2379277 2379277 defendant Tysynges John yeoman 607720 607720 Tysynges, John, of Cathorp, yeoman 0
5136451 2397177 2397177 plaintiff Nowell or Newell Charles esq 607720 607720 Nowell or Newell, Charles, of Cathorp, esq 0
5136456 2397179 2397179 plaintiff Nowell Charles esq 607720 607720 Nowell, Charles, of Cathorp, esq 0
5228863 2424050 2424050 defendant Milner Thomas miller 607720 607720 Milner, Thomas, of Cathorp, miller 1
5246397 2429107 2429107 plaintiff Sanderson John   607720 607720 Sanderson, John, of Cathorp 0
5256122 2432039 2432039 defendant Sayne or Sayve John mercer 607720 607720 Sayne or Sayve, John, of Cathorp, mercer 0
5321439 2451506 2451506 defendant Came Thomas gent 607720 607720 Came, Thomas, of Cathorp, gent 0
5375012 2467777 2467777 defendant Daynell Robert husbandman 607720 607720 Daynell, Robert, of Cathorp, husbandman 1
5431060 2484228 2484228 plaintiff Hykson John   607720 607720 Hykson, John, of Cathorp 0
5447647 2489168 2489168 plaintiff Hykson John   607720 607720 Hykson, John, of Cathorp 0
5459693 2492819 2492819 plaintiff Hikson John   607720 607720 Hikson, John, of Cathorp 0
5471385 2496384 2496384 plaintiff Hikson John   607720 607720 Hikson, John, of Cathorp 0

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