names

51 rows where place_id = 587778

✎ 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
3592406 1865240 1865240 defendant Twynham John tailor 587778 587778 Twynham, John, of Soberton, tailor 2
3709285 1929200 1929200 defendant Multon George gent 587778 587778 Multon, George, of Soberton, gent 0
4416984 2170181 2170181 plaintiff Pottere Ellis le   587778 587778 Pottere, Ellis le, of Soberton 0
4465163 2189763 2189763 defendant Portour Simon   587778 587778 Portour, Simon, of Soberton 0
4491914 2198156 2198156 defendant Doppyng Thomas   587778 587778 Doppyng, Thomas, of Soberton 0
4491915 2198156 2198156 defendant Kayt Richard   587778 587778 Kayt, Richard, of Soberton 1
4509748 2203533 2203533 defendant Doppyng John   587778 587778 Doppyng, John, of Soberton 0
4545766 2214603 2214603 plaintiff Boole William   587778 587778 Boole, William, of Soberton 0
4567286 2221326 2221326 defendant Dodde John   587778 587778 Dodde, John, of Soberton 0
4572514 2222938 2222938 defendant Stokkers Alice   587778 587778 Stokkers, Alice, of Soberton 0
4581016 2225542 2225542 defendant Kerbrigg John   587778 587778 Kerbrigg, John, of Soberton 0
4613729 2235308 2235308 defendant Deppynge John (legal representative) 587778 587778 Deppynge, John, of Soberton, executors of 0
4617075 2236348 2236348 plaintiff Gille Thomas   587778 587778 Gille, Thomas, of Soberton 0
4632929 2241170 2241170 plaintiff Waleys Robert   587778 587778 Waleys, Robert, of Soberton 0
4656516 2247934 2247934 plaintiff Cayte Thomas   587778 587778 Cayte, Thomas, of Soberton 0
4690826 2262662 2262662 defendant Lyghe Roger husbandman 587778 587778 Lyghe, Roger, of Soberton, husbandman 0
4691219 2262772 2262772 defendant Lygh Robert husbandman 587778 587778 Lygh, Robert, of Soberton, husbandman 5
4702329 2266138 2266138 defendant Rede William husbandman 587778 587778 Rede, William, of Soberton, husbandman 0
4705732 2267165 2267165 defendant Spycer Richard gent 587778 587778 Spycer, Richard, of Soberton, gent 0
4705733 2267165 2267165 defendant Estene John gent 587778 587778 Estene, John, of Soberton, gent 1
4705735 2267166 2267166 defendant Spicer Richard gent 587778 587778 Spicer, Richard, of Soberton, gent 0
4705736 2267166 2267166 defendant Estone John gent 587778 587778 Estone, John, of Soberton, gent 1
4716295 2270406 2270406 defendant Spycer Richard esq 587778 587778 Spycer, Richard, of Soberton, esq 0
4716588 2270506 2270506 defendant Bolt William   587778 587778 Bolt, William, of Soberton, hay ward 0
4724319 2272905 2272905 plaintiff Estney John   587778 587778 Estney, John, of Soberton 0
4724320 2272905 2272905 defendant Howell Thomas tailor 587778 587778 Howell, Thomas, of Soberton, tailor 0
4724322 2272905 2272905 defendant Estwode John husbandman 587778 587778 Estwode, John, of Soberton, husbandman 2
4728075 2274027 2274027 defendant Knoller John shoemaker 587778 587778 Knoller, John, of Soberton, shoemaker 0
4735779 2276339 2276339 defendant Legh Robert skinner 587778 587778 Legh, Robert, of Soberton, skinner 0
4737446 2276827 2276827 defendant atte Lee Thomas husbandman 587778 587778 atte Lee, Thomas, of Soberton, husbandman 0
4737447 2276827 2276827 defendant Lyghte Robert husbandman 587778 587778 Lyghte, Robert, of Soberton, husbandman 1
4847297 2310656 2310656 defendant Fosard Nicholas   587778 587778 Fosard, Nicholas, of Soberton, mason 0
4847298 2310656 2310656 defendant Fosard Edward yeoman 587778 587778 Fosard, Edward, of Soberton, yeoman 1
4851646 2311950 2311950 defendant Wyther John   587778 587778 Wyther, John, of Soberton, bailiff 0
4870698 2317812 2317812 defendant Lygh Robert skinner 587778 587778 Lygh, Robert, of Soberton, skinner 1
4905823 2328424 2328424 defendant Neweport Elizabeth   587778 587778 Neweport, Elizabeth, of Soberton, widow of Neweport, Richard 0
4905824 2328424 2328424 defendant Neweport Richard gent 587778 587778 Neweport, Richard, of Soberton, gent 1
4905829 2328426 2328426 defendant Dommer John   587778 587778 Dommer, John, of Soberton, single man 0
4905830 2328426 2328426 defendant Baron Richard husbandman 587778 587778 Baron, Richard, of Soberton, husbandman 1
4905831 2328426 2328426 defendant Forster John husbandman 587778 587778 Forster, John, of Soberton, husbandman 2
4913285 2330655 2330655 defendant Lyghe Robert skinner 587778 587778 Lyghe, Robert, of Soberton, skinner 0
5009338 2359620 2359620 defendant Bole John yeoman 587778 587778 Bole, John, of Soberton, yeoman 4
5029986 2365646 2365646 defendant Caldewell Lawrence husbandman 587778 587778 Caldewell, Lawrence, of Soberton, husbandman 0
5048492 2371188 2371188 defendant Estwod John husbandman 587778 587778 Estwod, John, of Soberton, husbandman 1
5282040 2439819 2439819 defendant Neuport Richard gent 587778 587778 Neuport, Richard, of Soberton, gent 0
5289851 2442039 2442039 defendant Wrayale or Wraxale Nicholas husbandman 587778 587778 Wrayale or Wraxale, Nicholas, of Soberton, husbandman 0
5289852 2442039 2442039 defendant Serle John husbandman 587778 587778 Serle, John, of Soberton, husbandman 1
5310476 2448170 2448170 defendant Higham Agnes widow 587778 587778 Higham, Agnes, of Soberton, widow 0
5319367 2450885 2450885 defendant Twyneham John tailor 587778 587778 Twyneham, John, of Soberton, tailor 0
5319368 2450885 2450885 defendant Arthour William smith 587778 587778 Arthour, William, of Soberton, smith 1
5630195 2553449 2553449 defendant Waleys Robert husbandman 587778 587778 Waleys, Robert, of Soberton, husbandman 1

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