names

70 rows where place_id = 611449

✎ 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
3688470 1922548 1922548 plaintiff Dalle William   611449 611449 Dalle, William, of Cley 0
3702448 1927027 1927027 defendant Webster John husbandman 611449 611449 Webster, John, of Cley, husbandman 0
3703292 1927303 1927303 plaintiff Dalle William   611449 611449 Dalle, William, of Cley 0
3717140 1931646 1931646 plaintiff Dalle William   611449 611449 Dalle, William, of Cley 0
3732307 1936344 1936344 defendant Collys Thomas   611449 611449 Collys, Thomas, of Cley, freemason 0
3759719 1945033 1945033 plaintiff Colles Thomas   611449 611449 Colles, Thomas, of Cley 0
3759722 1945033 1945033 defendant Smalle John mariner 611449 611449 Smalle, John, of Cley, mariner 2
3759723 1945033 1945033 defendant Castlowe John mariner 611449 611449 Castlowe, John, of Cley, mariner 3
3760058 1945143 1945143 defendant Marteyns Mathew glasier 611449 611449 Marteyns, Mathew, of Cley, glasier 0
3776431 1950383 1950383 defendant Colles Thomas   611449 611449 Colles, Thomas, of Cley, freemason 0
3794410 1956127 1956127 defendant Chylde Nicholas clerk 611449 611449 Chylde, Nicholas, of Cley, clerk 0
3799583 1957790 1957790 defendant Dobbes William (legal representative) 611449 611449 Dobbes, William, of Cley, cooper, executrix of 0
3821291 1964551 1964551 defendant Mannyng John tailor 611449 611449 Mannyng, John, of Cley, tailor 0
3831625 1967787 1967787 plaintiff Hall John draper 611449 611449 Hall, John, of Cley, draper 0
3832239 1967998 1967998 plaintiff Hoke Robert   611449 611449 Hoke, Robert, of Cley 0
3844120 1971707 1971707 defendant Symondes Ralph gent 611449 611449 Symondes, Ralph, of Cley, gent 0
3846694 1972521 1972521 defendant Symondes Ralph gent 611449 611449 Symondes, Ralph, of Cley, gent 0
3886637 1985783 1985783 defendant Cobbe Thomas yeoman 611449 611449 Cobbe, Thomas, of Cley, yeoman 1
3893998 1988210 1988210 defendant Alyston James mercer 611449 611449 Alyston, James, of Cley, mercer 3
3895961 1988853 1988853 plaintiff Symonde Ralph esq 611449 611449 Symonde, Ralph, of Cley, esq 0
3898172 1989594 1989594 defendant Webster John   611449 611449 Webster, John, of Cley 1
3900356 1990355 1990355 defendant Myller John draper 611449 611449 Myller, John, of Cley, draper 0
3918246 1996435 1996435 defendant Dowell Robert mariner 611449 611449 Dowell, Robert, of Cley, mariner 1
3919271 1996775 1996775 defendant Dowell Robert   611449 611449 Dowell, Robert, of Cley, ship master 2
3944098 2005044 2005044 defendant Grey Robert mariner 611449 611449 Grey, Robert, of Cley, mariner 4
3973045 2015143 2015143 defendant Wylkynson Richard mariner 611449 611449 Wylkynson, Richard, of Cley, mariner 0
3985163 2019449 2019449 defendant Thurcocke Robert (legal representative) 611449 611449 Thurcocke, Robert, of Cley, executors of 0
3999814 2024696 2024696 defendant Shilling Henry mariner 611449 611449 Shilling, Henry, of Cley, mariner 0
3999821 2024699 2024699 defendant Shilling Henry mariner 611449 611449 Shilling, Henry, of Cley, mariner 1
4000418 2024917 2024917 defendant Astell Richard merchant 611449 611449 Astell, Richard, of Cley, merchant 2
4048788 2042013 2042013 defendant Fyssheman John mercer 611449 611449 Fyssheman, John, of Cley, mercer 2
4049284 2042190 2042190 defendant Fyssheman John mercer 611449 611449 Fyssheman, John, of Cley, mercer 3
4064013 2047411 2047411 defendant Penyten Robert carpenter 611449 611449 Penyten, Robert, of Cley, carpenter 1
4124021 2068891 2068891 defendant Bockynge John husbandman 611449 611449 Bockynge, John, of Cley, husbandman 0
4174360 2086496 2086496 defendant Rose peter butcher 611449 611449 Rose, peter, of Cley, butcher 3
4198509 2095030 2095030 defendant Ellyson James, senior mercer 611449 611449 Ellyson, James, senior, of Cley, mercer 0
4243206 2110719 2110719 defendant Hanson John husbandman 611449 611449 Hanson, John, of Cley, husbandman 3
4286870 2125361 2125361 defendant Gogney William fishmonger 611449 611449 Gogney, William, of Cley, fishmonger 0
4383484 2159184 2159184 defendant Hynde William butcher 611449 611449 Hynde, William, of Cley, butcher 2
4390063 2161297 2161297 defendant Hallyday Edward yeoman 611449 611449 Hallyday, Edward, of Cley, tailor, or of Holt Market, yeoman 0
4565160 2220674 2220674 defendant Wryght John   611449 611449 Wryght, John, of Cley 0
4690289 2262518 2262518 defendant Dustgate John husbandman 611449 611449 Dustgate, John, of Cley, husbandman 0
4690290 2262518 2262518 defendant Maloth Thomas, junior husbandman 611449 611449 Maloth, Thomas, junior, of Cley, husbandman 1
4704673 2266841 2266841 defendant Smyth Thomas smith 611449 611449 Smyth, Thomas, of Cley Hanger, smith 1
4709001 2268184 2268184 defendant Bode or Gode Simon   611449 611449 Bode or Gode, Simon, of Cley, servant 0
4745911 2279309 2279309 defendant Herryesson Robert mercer 611449 611449 Herryesson, Robert, of Cley, executors of(Lovell, Thomas, of Cleye, next the sea, mercer 2
4800398 2296305 2296305 defendant Sheder Thomas shipman 611449 611449 Sheder, Thomas, of Cley, shipman 1
4866092 2316367 2316367 defendant Roweland Simon shipman 611449 611449 Roweland, Simon, of Cley, shipman 0
4866100 2316370 2316370 defendant Roweland Simon shipman 611449 611449 Roweland, Simon, of Cley, shipman 0
4866101 2316370 2316370 defendant Collys William   611449 611449 Collys, William, of Cley, mason 1
4866103 2316370 2316370 defendant Clement Edmund shipman 611449 611449 Clement, Edmund, of Cley, shipman 3
4913323 2330665 2330665 defendant Parker Robert yeoman 611449 611449 Parker, Robert, of Cley, yeoman 1
4913324 2330665 2330665 defendant Fuller Thomas yeoman 611449 611449 Fuller, Thomas, of Cley, yeoman 2
4998764 2356519 2356519 defendant Cropper Richard husbandman 611449 611449 Cropper, Richard, of Cley, husbandman 0
5025839 2364458 2364458 defendant Cley John husbandman 611449 611449 Cley, John, of Cley, husbandman 0
5025840 2364458 2364458 defendant Lodnam Walter husbandman 611449 611449 Lodnam, Walter, of Cley, husbandman 1
5025841 2364458 2364458 defendant Bacun William husbandman 611449 611449 Bacun, William, of Cley, husbandman 2
5025842 2364458 2364458 defendant Cropper Richard husbandman 611449 611449 Cropper, Richard, of Cley, husbandman 3
5031393 2366038 2366038 defendant Fller Katherine widow 611449 611449 Fller, Katherine, of Cley, widow 0
5080168 2380557 2380557 plaintiff Clement Edmund   611449 611449 Clement, Edmund, of Cley 0
5080170 2380558 2380558 plaintiff Clement Edmund   611449 611449 Clement, Edmund, of Cley 0
5080172 2380559 2380559 plaintiff Clement Edmund   611449 611449 Clement, Edmund, of Cley 0
5133083 2396162 2396162 plaintiff Hooker William   611449 611449 Hooker, William, of Cley 1
5138820 2397854 2397854 defendant Chapman Richard husbandman 611449 611449 Chapman, Richard, of Cley, husbandman 1
5271771 2436841 2436841 plaintiff Hecler Robert   611449 611449 Hecler, Robert, of Cley 0
5271774 2436841 2436841 defendant Torald Robert (legal representative) 611449 611449 Torald, Robert, of Cley, husbandman, executrix of 2
5290016 2442086 2442086 plaintiff Multon Robert   611449 611449 Multon, Robert, of Cley 0
5522197 2511760 2511760 plaintiff Dalle alias Hooker William   611449 611449 Dalle alias Hooker, William, of Cley 0
5522200 2511760 2511760 defendant Cley John mariner 611449 611449 Cley, John, of Cley, mariner 2
5586575 2530837 2530837 plaintiff Lose John   611449 611449 Lose, John, of Cley 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);