names

77 rows where place_id = 587969

✎ 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
3592989 1865433 1865433 defendant Haynes Hugh husbandman 587969 587969 Haynes, Hugh, of Cotes, husbandman 1
3607679 1870057 1870057 defendant Smyth Robert husbandman 587969 587969 Smyth, Robert, of Cotes, husbandman 1
3607683 1870058 1870058 defendant Smyth Robert husbandman 587969 587969 Smyth, Robert, of Cotes, husbandman 1
3614383 1872147 1872147 defendant Irlond Joan widow 587969 587969 Irlond, Joan, of Cotes, widow 1
3635858 1906014 1906014 defendant Halyday John husbandman 587969 587969 Halyday, John, of Cotes, husbandman 0
3679638 1919699 1919699 defendant Assheton Walter yeoman 587969 587969 Assheton, Walter, of Cotes, yeoman 0
3682446 1920610 1920610 defendant Kemys Henry gent 587969 587969 Kemys, Henry, of Cotes, gent 1
3697596 1925470 1925470 defendant Kemys Henry gent 587969 587969 Kemys, Henry, of Cotes, gent 0
3705425 1927984 1927984 defendant Assheton Walter yeoman 587969 587969 Assheton, Walter, of Cotes, yeoman 0
3705426 1927984 1927984 defendant Hogg William chaplain 587969 587969 Hogg, William, of Cotes, chaplain 1
3705428 1927985 1927985 defendant Hogge William chaplain 587969 587969 Hogge, William, of Cotes, chaplain 0
3705429 1927985 1927985 defendant Asshton Walter yeoman 587969 587969 Asshton, Walter, of Cotes, yeoman 1
3867273 1979288 1979288 defendant Barnys Thomas   587969 587969 Barnys, Thomas, of Cotes, husbandma 2
3992481 2022073 2022073 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes , esq, executors of 0
3992485 2022074 2022074 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes , esq, executors of 0
3992575 2022096 2022096 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992579 2022097 2022097 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992583 2022098 2022098 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992587 2022099 2022099 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992591 2022100 2022100 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992595 2022101 2022101 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992599 2022102 2022102 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992603 2022103 2022103 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992608 2022104 2022104 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992612 2022105 2022105 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
3992616 2022106 2022106 plaintiff Butler Anthony (legal representative) 587969 587969 Butler, Anthony, of Cotes, esq, executors of 0
4060166 2046036 2046036 defendant Armond Robert clerk 587969 587969 Armond, Robert, of Cotes, clerk 0
4068528 2049033 2049033 defendant Powltue or Powltne John yeoman 587969 587969 Powltue or Powltne, John, of Cotes, yeoman 0
4086773 2055557 2055557 defendant Wyldynge John yeoman 587969 587969 Wyldynge, John, of Cotes, yeoman 0
4086775 2055557 2055557 defendant Wyldynge Robert yeoman 587969 587969 Wyldynge, Robert, of Cotes, yeoman 2
4101114 2060711 2060711 defendant Poultne John yeoman 587969 587969 Poultne, John, of Cotes, yeoman 0
4214936 2100725 2100725 defendant Heath William husbandman 587969 587969 Heath, William, of Cotes, husbandman 0
4215088 2100778 2100778 defendant Everall William husbandman 587969 587969 Everall, William, of Cotes, husbandman 0
4367959 2153589 2153589 defendant Welborne Robert yeoman 587969 587969 Welborne, Robert, of Cotes, yeoman 0
4386534 2160171 2160171 defendant Everall William husbandman 587969 587969 Everall, William, of Cotes, husbandman 0
4386535 2160171 2160171 defendant Everall Roland husbandman 587969 587969 Everall, Roland, of Cotes, husbandman 1
4386536 2160171 2160171 defendant Everall Edward husbandman 587969 587969 Everall, Edward, of Cotes, husbandman 2
4417277 2170288 2170288 plaintiff Salathiel Alicia   587969 587969 Salathiel, Alicia, of Cotes, formerly wife of John 0
4428728 2173785 2173785 defendant Brounyng Alice   587969 587969 Brounyng, Alice, of Cotes 6
4436275 2176090 2176090 plaintiff Salathiel Alice   587969 587969 Salathiel, Alice, of Cotes, formerly wife of John 0
4442652 2182651 2182651 defendant Budel John   587969 587969 Budel, John, of Cotes 0
4451500 2185440 2185440 defendant Longwille William   587969 587969 Longwille, William, of Cotes 4
4482147 2195126 2195126 defendant Dally Nicholas   587969 587969 Dally, Nicholas, of Cotes 0
4499505 2200491 2200491 defendant Baker William   587969 587969 Baker, William, of Cotes 6
4518181 2206059 2206059 defendant del Cotes William   587969 587969 del Cotes, William, of Cotes 0
4552919 2216857 2216857 plaintiff Freman Isabel   587969 587969 Freman, Isabel, of Cotes, formerly wife of William 0
4562257 2219764 2219764 plaintiff Pontrel Amice   587969 587969 Pontrel, Amice, of Cotes, formerly wife of George, son of John 0
4564972 2220612 2220612 defendant Colyer Robert   587969 587969 Colyer, Robert, of Cotes 0
4569797 2222128 2222128 defendant Rome (illegible) chaplain 587969 587969 Rome, _, of Cotes, chaplain 8
4665675 2250734 2250734 defendant Rye William Hostiler Williamservant yeoman 587969 587969 Rye, William Hostiler Williamservant, of Cotes, yeoman 1
4665676 2250734 2250734 defendant Bury John yeoman 587969 587969 Bury, John, of Cotes, yeoman 2
4668257 2255785 2255785 defendant Willardby John husbandman 587969 587969 Willardby, John, of Cotes, husbandman 0
4698995 2265159 2265159 defendant Rye William gent 587969 587969 Rye, William, of Cotes, gent 0
4763193 2284475 2284475 defendant Veel Maud   587969 587969 (Veel, Maud, of Cotes, widow, formerly wife of John 1
4763194 2284475 2284475 defendant Mathowe John, sen husbandman 587969 587969 Mathowe, John, sen, of Cotes, husbandman 2
4783396 2290822 2290822 defendant Becok John husbandman 587969 587969 Becok, John, of Cotes, husbandman 3
4860284 2314575 2314575 plaintiff Chylde John   587969 587969 Chylde, John, of Cotes 0
4903074 2327576 2327576 defendant Broun Adam (legal representative) 587969 587969 Broun, Adam, of Cotes, executors of 0
4904991 2328164 2328164 defendant Wattes John, junior husbandman 587969 587969 Wattes, John, junior, of Cotes, husbandman 0
4923765 2333875 2333875 defendant Mathewe John, junior husbandman 587969 587969 Mathewe, John, junior, of Cotes, husbandman 1
4934971 2337343 2337343 plaintiff Bartelot John esq 587969 587969 Bartelot, John, of Cotes, esq 0
4953392 2342980 2342980 defendant Fodyrby John husbandman 587969 587969 Fodyrby, John, of Cotes, husbandman 0
4994949 2355348 2355348 plaintiff Fuller John   587969 587969 Fuller, John, of Cotes 0
5053530 2372659 2372659 defendant Twe John husbandman 587969 587969 Twe, John, of Cotes, husbandman 1
5068175 2376984 2376984 defendant Potycar John husbandman 587969 587969 Potycar, John, of Cotes, husbandman 0
5077404 2379742 2379742 defendant Bandman Thomas   587969 587969 Bandman, Thomas, of Cotes, administrators of 2
5149539 2400994 2400994 defendant Knyght William esq 587969 587969 Knyght, William, of Cotes, esq 1
5179542 2409749 2409749 defendant Hopton William (legal representative) 587969 587969 Hopton, William, of Cotes, gent, executors of 0
5310170 2448074 2448074 defendant Tayllour William husbandman 587969 587969 Tayllour, William, of Cotes, husbandman 3
5431369 2484336 2484336 plaintiff Kelke Thomas clerk & parson 587969 587969 Kelke, Thomas, of Cotes, clerk & parson 0
5440544 2487078 2487078 defendant Stanfeld Thomas   587969 587969 Stanfeld, Thomas, of Cotes, skep maker 2
5441375 2487338 2487338 defendant Stanfeld Thomas skipmaker 587969 587969 Stanfeld, Thomas, of Cotes, skipmaker 2
5504689 2506385 2506385 defendant Wayte John, senior husbandman 587969 587969 Wayte, John, senior, of Cotes, husbandman 1
5512060 2508632 2508632 defendant Wodeward William yeoman 587969 587969 Wodeward, William, of Cotes, yeoman 1
5543692 2518136 2518136 defendant Haynes Hugh husbandman 587969 587969 Haynes, Hugh, of Cotes, husbandman 0
5584676 2530277 2530277 defendant Wadyngton John yeoman 587969 587969 Wadyngton, John, of Cotes, yeoman 1
5610191 2546901 2546901 defendant Lovelyng Richard   587969 587969 Lovelyng, Richard, of Cotes 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);