names

106 rows where place_id = 586022

✎ 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
3587715 1863805 1863805 defendant Fyldyng Everard esq 586022 586022 Fyldyng, Everard, of Lutterworth, Leics, esq 0
3590916 1864786 1864786 defendant Thomas Richard yeoman 586022 586022 Thomas, Richard, of Lutterworth, Leics, yeoman 3
3604207 1868981 1868981 defendant Boull William butcher 586022 586022 Boull, William, of Lutterworth, Leics, butcher 0
3604211 1868982 1868982 defendant Boull William butcher 586022 586022 Boull, William, of Lutterworth, Leics, butcher 1
3619500 1873664 1873664 defendant Weld John sherman 586022 586022 Weld, John, of Lutterworth, Leics, sherman 0
3686161 1921835 1921835 defendant Knottysford Humphrey chaplain 586022 586022 Knottysford, Humphrey, of Lutterworth, Leics, chaplain 0
3715538 1931146 1931146 defendant Knottysford Humphrey master of Spytull Hospital 586022 586022 Knottysford, Humphrey, of Lutterworth, Leics, clerk, master of Spytull Hospital 1
3749237 1941687 1941687 defendant Randesdale Thomas husbandman 586022 586022 Randesdale, Thomas, of Lutterworth, Leics, husbandman 3
3764079 1946410 1946410 defendant Randesdale Thomas husbandman 586022 586022 Randesdale, Thomas, of Lutterworth, Leics, husbandman 3
3784387 1952895 1952895 defendant Coton Nicholas smith 586022 586022 Coton, Nicholas, of Lutterworth, Leics, smith 0
3784389 1952896 1952896 defendant Cotton Nicholas smith 586022 586022 Cotton, Nicholas, of Lutterworth, Leics, smith 0
3785916 1953389 1953389 defendant Hynde Thomas husbandman 586022 586022 Hynde, Thomas, of Lutterworth, Leics, husbandman 0
3785918 1953390 1953390 defendant Hynde Thomas husbandman 586022 586022 Hynde, Thomas, of Lutterworth, Leics, husbandman 0
3805008 1959511 1959511 defendant Geyne Nicholas husbandman 586022 586022 Geyne, Nicholas, of Lutterworth, Leics, husbandman 2
3880117 1983604 1983604 plaintiff Pavear Robert mercer 586022 586022 Pavear, Robert, of Lutterworth, Leics, mercer 0
3972747 2015040 2015040 defendant Mowyer alias More Robert chapman 586022 586022 Mowyer alias More, Robert, of Lutterworth, Leics, chapman 0
3983342 2018815 2018815 defendant More Robert chapman 586022 586022 More, Robert, of Lutterworth, Leics, chapman 0
3986553 2019931 2019931 defendant Insley Thomas yeoman 586022 586022 Insley, Thomas, of Lutterworth, Leics, yeoman 2
3992691 2022136 2022136 defendant Worlawghton Thomas yeoman 586022 586022 Worlawghton, Thomas, of Lutterworth, Leics, yeoman 1
4035628 2037417 2037417 defendant Brodgate William yeoman 586022 586022 Brodgate, William, of Lutterworth, Leics, yeoman 0
4040078 2038949 2038949 defendant Bentley John yeoman or wool buyer 586022 586022 Bentley, John, of Lutterworth, Leics, yeoman or wool buyer 0
4041212 2039346 2039346 defendant Bentley John yeoman or wool buyer 586022 586022 Bentley, John, of Lutterworth, Leics, yeoman or wool buyer 0
4059331 2045729 2045729 defendant Pratt John yeoman 586022 586022 Pratt, John, of Lutterworth, Leics, yeoman 0
4144957 2076396 2076396 defendant Brodgate Henry yeoman 586022 586022 Brodgate, Henry, of Lutterworth, Leics, yeoman 0
4193210 2093194 2093194 defendant Lussell Hugh yeoman 586022 586022 Lussell, Hugh, of Lutterworth, Leics, yeoman 0
4218535 2101981 2101981 defendant Yonge John yeoman 586022 586022 Yonge, John, of Lutterworth, Leics, yeoman 1
4218538 2101982 2101982 defendant Yonge John yeoman 586022 586022 Yonge, John, of Lutterworth, Leics, yeoman 1
4237041 2108537 2108537 defendant Page Humphrey poulter 586022 586022 Page, Humphrey, of Lutterworth, Leics, poulter 0
4251360 2113435 2113435 defendant Clement Edward gent 586022 586022 Clement, Edward, of Lutterworth, Leics, clerk, or of Sandon, Essex, gent 0
4251362 2113436 2113436 defendant Clement Edward gent 586022 586022 Clement, Edward, of Lutterworth, Leics, clerk, or of Sandon, Essex, gent 0
4257711 2115553 2115553 defendant Page Humphrey poulter 586022 586022 Page, Humphrey, of Lutterworth, Leics, poulter 0
4272756 2120455 2120455 defendant Clement Edmund clerk 586022 586022 Clement, Edmund, of Lutterworth, Leics, clerk 3
4279880 2122875 2122875 defendant Clement Edward clerk 586022 586022 Clement, Edward, of Lutterworth, Leics, clerk 1
4292603 2127414 2127414 defendant Clement Edward clerk 586022 586022 Clement, Edward, of Lutterworth, Leics, clerk 0
4311637 2134213 2134213 defendant Wood William glover 586022 586022 Wood, William, of Lutterworth, Leics, glover 0
4319142 2136812 2136812 defendant Lussell Hugh yeoman 586022 586022 Lussell, Hugh, of Lutterworth, Leics, yeoman 0
4321718 2137684 2137684 defendant Clement Edmund clerk 586022 586022 Clement, Edmund, of Lutterworth, Leics, clerk 4
4329150 2140061 2140061 defendant Clement Edward clerk 586022 586022 Clement, Edward, of Lutterworth, Leics, clerk 2
4357182 2149741 2149741 defendant Waight Nicholas yeoman 586022 586022 Waight, Nicholas, of Lutterworth, Leics, yeoman 0
4373681 2155655 2155655 defendant Wyett Nicholas yeoman 586022 586022 Wyett, Nicholas, of Lutterworth, Leics, yeoman 2
4387499 2160464 2160464 defendant Damporte Thomas chapman 586022 586022 Damporte, Thomas, of Lutterworth, Leics, chapman 1
4667727 2255618 2255618 defendant Trypp John chapman 586022 586022 Trypp, John, of Lutterworth, Leics, chapman 1
4667730 2255619 2255619 defendant Tripp John chapman 586022 586022 Tripp, John, of Lutterworth, Leics, chapman 1
4685862 2261169 2261169 defendant Fyldyng William gent 586022 586022 Fyldyng, William, of Lutterworth, Leics, gent 0
4726211 2273481 2273481 defendant Skryven John yeoman 586022 586022 Skryven, John, of Lutterworth, Leics, yeoman 0
4726212 2273481 2273481 defendant Tryppe John yeoman 586022 586022 Tryppe, John, of Lutterworth, Leics, yeoman 1
4726215 2273482 2273482 defendant Skryven John yeoman 586022 586022 Skryven, John, of Lutterworth, Leics, yeoman 0
4726216 2273482 2273482 defendant Tryppe John yeoman 586022 586022 Tryppe, John, of Lutterworth, Leics, yeoman 1
4729691 2274497 2274497 defendant Stone William tailor 586022 586022 Stone, William, of Lutterworth, Leics, tailor 1
4729696 2274498 2274498 defendant Stone William tailor 586022 586022 Stone, William, of Lutterworth, Leics, tailor 1
4733909 2275790 2275790 defendant Trip John mercer 586022 586022 Trip, John, of Lutterworth, Leics, mercer 0
4744677 2278963 2278963 defendant Stone William yeoman 586022 586022 Stone, William, of Lutterworth, Leics, yeoman 3
4770212 2286656 2286656 defendant Swage Thomas chapman 586022 586022 Swage, Thomas, of Lutterworth, Leics, chapman 1
4806488 2298241 2298241 defendant Tryp John chapman 586022 586022 Tryp, John, of Lutterworth, Leics, chapman 0
4877387 2319882 2319882 defendant Serieant Robert husbandman 586022 586022 Serieant, Robert, of Lutterworth, Leics, husbandman 1
4879733 2320580 2320580 defendant Overton John (legal representative) 586022 586022 Overton, John, of Lutterworth, Leics, executrix of 0
4899980 2326633 2326633 defendant Fayrman Thomas yeoman 586022 586022 Fayrman, Thomas, of Lutterworth, Leics, yeoman 0
5068923 2377205 2377205 defendant Hochet John husandman 586022 586022 Hochet, John, of Lutterworth, Leics, husandman 0
5068927 2377206 2377206 defendant Hochet John husbandman 586022 586022 Hochet, John, of Lutterworth, Leics, husbandman 0
5071750 2378042 2378042 defendant Middelham Richard butcher 586022 586022 Middelham, Richard, of Lutterworth, Leics, butcher 1
5072171 2378165 2378165 defendant Farmon Thomas husbandman 586022 586022 Farmon, Thomas, of Lutterworth, Leics, husbandman 3
5127457 2394505 2394505 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 2
5139043 2397912 2397912 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 2
5146311 2400050 2400050 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 3
5159900 2403992 2403992 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 2
5159904 2403993 2403993 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 2
5166519 2405926 2405926 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 2
5181331 2410282 2410282 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 0
5181370 2410294 2410294 defendant Beyr John   586022 586022 (Beyr, John, of Lutterworth, Leics, 5
5188775 2412446 2412446 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 0
5188777 2412447 2412447 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 0
5188779 2412448 2412448 defendant Bere John widow 586022 586022 Bere, John, of Lutterworth, Leics, widow 0
5198513 2415317 2415317 defendant Twyst Richard carpenter 586022 586022 Twyst, Richard, of Lutterworth, Leics, carpenter 0
5198515 2415318 2415318 defendant Twyst Richard carpenter 586022 586022 Twyst, Richard, of Lutterworth, Leics, carpenter 0
5198517 2415319 2415319 defendant Twyst Richard carpenter 586022 586022 Twyst, Richard, of Lutterworth, Leics, carpenter 0
5206255 2417563 2417563 defendant Bere Joan widow 586022 586022 Bere, Joan, of Lutterworth, Leics, widow 0
5210585 2418832 2418832 defendant Twyst Richard carpenter 586022 586022 Twyst, Richard, of Lutterworth, Leics, carpenter 0
5210587 2418833 2418833 defendant Twyst Richard carpenter 586022 586022 Twyst, Richard, of Lutterworth, Leics, carpenter 0
5212522 2419409 2419409 defendant Wardon Simon butcher 586022 586022 Wardon, Simon, of Lutterworth, Leics, butcher 0
5212524 2419410 2419410 defendant Wardon Simon butcher 586022 586022 Wardon, Simon, of Lutterworth, Leics, butcher 0
5240279 2427366 2427366 defendant Conway Hugh woolman 586022 586022 Conway, Hugh, of Lutterworth, Leics, woolman 0
5251378 2430529 2430529 defendant Beele Thomas miller 586022 586022 Beele, Thomas, of Lutterworth, Leics, miller 0
5253509 2431199 2431199 defendant Edmond John husbandman 586022 586022 Edmond, John, of Lutterworth, Leics, husbandman 1
5255456 2431828 2431828 defendant Taillour alias Conway Hugh yeoman 586022 586022 Taillour alias Conway, Hugh, of Lutterworth, Leics, yeoman 0
5268831 2435996 2435996 defendant Sergeant John husbandman 586022 586022 Sergeant, John, of Lutterworth, Leics, husbandman 2
5281765 2439739 2439739 defendant Brochole Richard yeoman 586022 586022 Brochole, Richard, of Lutterworth, Leics, yeoman 0
5313565 2449086 2449086 defendant Feldyng Agnes widow 586022 586022 Feldyng, Agnes, of Lutterworth, Leics, widow 1
5320915 2451343 2451343 defendant Brokehole Richard chapman 586022 586022 Brokehole, Richard, of Lutterworth, Leics, chapman 1
5325302 2452656 2452656 defendant Wryght Henry   586022 586022 Wryght, Henry, of Lutterworth, Leics, wright 0
5336252 2455917 2455917 defendant Brokhole William husbandman 586022 586022 Brokhole, William, of Lutterworth, Leics, husbandman 3
5336308 2455926 2455926 defendant Brokhole William husbandman 586022 586022 Brokhole, William, of Lutterworth, Leics, husbandman 2
5348341 2459622 2459622 defendant Sergeant John husbandman 586022 586022 Sergeant, John, of Lutterworth, Leics, husbandman 0
5413180 2478865 2478865 defendant Lewes Hugh clerk & master of the hospital of St Johh Baptist 586022 586022 Lewes, Hugh, of Lutterworth, Leics, clerk & master of the hospital of St Johh Baptist 0
5428342 2483401 2483401 defendant Lewes Hugh clerk & master of the hospital of St John Baptist 586022 586022 Lewes, Hugh, of Lutterworth, Leics, clerk & master of the hospital of St John Baptist 0
5428952 2483578 2483578 defendant Bull William butcher 586022 586022 Bull, William, of Lutterworth, Leics, butcher 0
5432999 2484835 2484835 defendant Cokkys William barber 586022 586022 Cokkys, William, of Lutterworth, Leics, barber 2
5454187 2491152 2491152 defendant Cokkys William barber 586022 586022 Cokkys, William, of Lutterworth, Leics, barber 1
5458772 2492516 2492516 defendant Bull William butcher 586022 586022 Bull, William, of Lutterworth, Leics, butcher 0
5458793 2492521 2492521 defendant Bull William butcher 586022 586022 Bull, William, of Lutterworth, Leics, butcher 0
5461117 2493269 2493269 defendant Cokkys William barber 586022 586022 Cokkys, William, of Lutterworth, Leics, barber 2

Next page

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