names

49 rows where place_id = 611023

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686407 1921902 1921902 defendant Gyles John gent 611023 611023 Gyles, John, of Nasyng, gent 0
3886178 1985626 1985626 defendant Campe Nicholas husbandman 611023 611023 Campe, Nicholas, of Nasyng, husbandman 1
3900564 1990419 1990419 defendant Gore John husbandman 611023 611023 Gore, John, of Nasyng, husbandman 0
4392579 2162137 2162137 defendant Hardyng or Hardyn Lawrence yeoman 611023 611023 Hardyng or Hardyn, Lawrence, of Nasyng, yeoman 0
4503366 2201623 2201623 defendant Ballard William   611023 611023 Ballard, William, of Nasyng 6
4616620 2236201 2236201 plaintiff Fyssher Simon   611023 611023 Fyssher, Simon, of Nasyng 0
4886780 2322720 2322720 plaintiff Grene John clerk 611023 611023 Grene, John, of Nasyng, clerk 1
4886781 2322720 2322720 defendant Spake Thomas   611023 611023 Spake, Thomas, of Nasyng 0
4925922 2334538 2334538 defendant Gore William   611023 611023 Gore, William, of Nasyng, groom 0
4928388 2335300 2335300 defendant Spake Thomas clerk 611023 611023 Spake, Thomas, of Nasyng, clerk 0
5018032 2362157 2362157 defendant Rypley John laborer 611023 611023 Rypley, John, of Nasyng, laborer 0
5077788 2379852 2379852 defendant Dabeney Simon collier 611023 611023 Dabeney, Simon, of Nasyng, collier 0
5077792 2379853 2379853 defendant Dabeney Simon collier 611023 611023 Dabeney, Simon, of Nasyng, collier 0
5083706 2381628 2381628 defendant Campes Thomas husbandman 611023 611023 Campes, Thomas, of Nasyng, husbandman 0
5083707 2381628 2381628 defendant Cays Nicholas husbandman 611023 611023 Cays, Nicholas, of Nasyng, husbandman 1
5118138 2391739 2391739 defendant Shelley Thomas yeoman 611023 611023 Shelley,Thomas, of Nasyng, yeoman 0
5139231 2397966 2397966 defendant Gugge or Engge Nicholas   611023 611023 Gugge or Engge, Nicholas, of Nasyng 0
5139232 2397966 2397966 defendant Neve Nicholas husbandman 611023 611023 Neve, Nicholas, of Nasyng, husbandman 1
5139233 2397966 2397966 defendant Davene Simon   611023 611023 Davene, Simon, of Nasyng 2
5230707 2424594 2424594 defendant Dyxson Thomas clerk 611023 611023 Dyxson, Thomas, of Nasyng, clerk 0
5230708 2424594 2424594 defendant Ive John husbandman 611023 611023 Ive, John, of Nasyng, husbandman 1
5230709 2424594 2424594 defendant Herd John husbandman 611023 611023 Herd, John, of Nasyng, husbandman 2
5230710 2424594 2424594 defendant Broun William husbandman 611023 611023 Broun, William, of Nasyng, husbandman 3
5242136 2427900 2427900 defendant Daloun John husbandman 611023 611023 Daloun, John, of Nasyng, husbandman 4
5260860 2433519 2433519 defendant Wether William husbandman 611023 611023 Wether, William, of Nasyng, husbandman 0
5273030 2437188 2437188 defendant Wytter William yeoman 611023 611023 Wytter, William, of Nasyng, yeoman 0
5307883 2447374 2447374 defendant Wytter William yeoman 611023 611023 Wytter, William, of Nasyng, yeoman 2
5313398 2449042 2449042 defendant Romayne John yeoman 611023 611023 Romayne, John, of Nasyng, yeoman 0
5313399 2449042 2449042 defendant Algore John husbandman 611023 611023 Algore, John, of Nasyng, husbandman 1
5323654 2452160 2452160 defendant Snawe Nicholas husbandman 611023 611023 Snawe, Nicholas, of Nasyng, husbandman 1
5354504 2461482 2461482 defendant att Wode John butcher 611023 611023 att Wode, John, of Nasyng, butcher 0
5354506 2461483 2461483 defendant atte Wode John butcher 611023 611023 atte Wode, John, of Nasyng, butcher 0
5375863 2468042 2468042 defendant Strykland Richard   611023 611023 Strykland, Richard, of Nasyng, cole maker 0
5376773 2468332 2468332 defendant Wylson Thomas husbandman 611023 611023 Wylson, Thomas, of Nasyng, husbandman 1
5376784 2468334 2468334 defendant Wylson Thomas husbandman 611023 611023 Wylson, Thomas, of Nasyng, husbandman 1
5458204 2492357 2492357 defendant Camp John husbandman 611023 611023 Camp, John, of Nasyng, husbandman 2
5469864 2495911 2495911 defendant Kamp John husbandman 611023 611023 Kamp, John, of Nasyng, husbandman 2
5481214 2499332 2499332 defendant Cramp John husbandman 611023 611023 Cramp, John, of Nasyng, husbandman 3
5481219 2499333 2499333 defendant Cramp John husbandman 611023 611023 Cramp, John, of Nasyng, husbandman 2
5483534 2500021 2500021 defendant Goldyng Nicholas husbandman 611023 611023 Goldyng, Nicholas, of Nasyng, husbandman 1
5498614 2504528 2504528 defendant Camp or Camper Nicholas husbandman 611023 611023 Camp or Camper, Nicholas, of Nasyng, husbandman 1
5505320 2506574 2506574 defendant Reynold John husbandman 611023 611023 Reynold, John, of Nasyng, husbandman 1
5507058 2507116 2507116 defendant Brewester John gent 611023 611023 Brewester, John, of Nasyng, gent 0
5507062 2507117 2507117 defendant Brewester John gent 611023 611023 Brewester, John, of Nasyng, gent 1
5507065 2507118 2507118 defendant Brewester John gent 611023 611023 Brewester, John, of Nasyng, gent 1
5523038 2512032 2512032 defendant Turnour Geoffrey weaver 611023 611023 Turnour, Geoffrey, of Nasyng, weaver 0
5587612 2531143 2531143 defendant Heynes Thomas laborer 611023 611023 Heynes, Thomas, of Nasyng, laborer 0
5609382 2537836 2537836 defendant Strykland Richard   611023 611023 Strykland, Richard, of Nasyng, cole maker 0
5634910 2554911 2554911 defendant Grove John husbandman 611023 611023 Grove, John, of Nasyng, husbandman 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);