names

257 rows where place_id = 606482

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3665375 1915124 1915124 defendant (illegible) William clerk 606482 606482 --, William, of Norfolk, clerk 0
3849466 1973433 1973433 plaintiff Lommor Edmund gent 606482 606482 Lommor, Edmund, of Norfolk, gent 0
3877103 1982584 1982584 plaintiff Reidon Henry gent 606482 606482 Reidon, Henry, of Norfolk, gent 1
3927728 1999611 1999611 defendant Gray Thomas yeoman 606482 606482 Gray, Thomas, of Norfolk, yeoman 2
3932905 2001295 2001295 defendant Benett John gent 606482 606482 Benett, John, of Norfolk, gent 1
3958666 2010106 2010106 plaintiff Rude Richard mercer 606482 606482 Rude, Richard, of Norfolk, mercer 0
4076535 2051905 2051905 defendant Cokett Anthony   606482 606482 Cokett, Anthony, of Norfolk, gent, his heir 1
4079806 2053077 2053077 defendant Catton Faith widow 606482 606482 Catton, Faith, of Norfolk, widow 1
4151354 2078596 2078596 defendant Shelton Thomas esq 606482 606482 Shelton, Thomas, of Norfolk, esq 0
4208125 2098398 2098398 defendant Jennytus John miller 606482 606482 Jennytus, John, of Norfolk, miller 2
4213797 2100343 2100343 defendant Skete Roger husbandman 606482 606482 Skete, Roger, of Norfolk, husbandman 2
4213798 2100343 2100343 defendant Becker Robert husbandman 606482 606482 Becker, Robert, of Norfolk, husbandman 3
4277020 2121895 2121895 defendant Harper William yeoman 606482 606482 Harper, William, of Norfolk, yeoman 2
4402667 2165477 2165477 defendant Haward Nicholas yeoman 606482 606482 Haward, Nicholas, of Norfolk, yeoman 4
4437891 2181173 2181173 defendant Hanham Robert   606482 606482 Hanham, Robert, of Norfolk 0
4437899 2181174 2181174 defendant Hanham Robert   606482 606482 Hanham, Robert, of Norfolk 0
4437906 2181175 2181175 defendant Hanham Robert   606482 606482 Hanham, Robert, of Norfolk 0
4444638 2183301 2183301 defendant Pescod Hugh   606482 606482 Pescod, Hugh, of Norfolk 0
4456240 2186973 2186973 defendant Eccles John   606482 606482 Eccles, John, of Norfolk, son of Reginald 0
4461270 2188609 2188609 plaintiff Wynter William   606482 606482 Wynter, William, of Norfolk 3
4469457 2191110 2191110 defendant Mayhewe John   606482 606482 Mayhewe, John, of Norfolk 3
4470517 2191425 2191425 defendant Banham Thomas   606482 606482 Banham, Thomas, of Norfolk 0
4471512 2191750 2191750 defendant Trencemener Robert   606482 606482 Trencemener, Robert, of Norfolk 1
4472296 2192008 2192008 defendant Pickyng John   606482 606482 Pickyng, John, of Norfolk 0
4472298 2192009 2192009 defendant Pickyng John   606482 606482 Pickyng, John, of Norfolk 0
4474700 2192751 2192751 defendant Holm John   606482 606482 Holm, John, of Norfolk 0
4474701 2192751 2192751 defendant Holmyng John   606482 606482 Holmyng, John, of Norfolk 1
4476585 2193336 2193336 defendant Frost Richard   606482 606482 Frost, Richard, of Norfolk 0
4496639 2199621 2199621 defendant Thorp John clerk 606482 606482 Thorp, John, of Norfolk, clerk 6
4498566 2200194 2200194 defendant Broklys John   606482 606482 Broklys, John, of Norfolk 1
4505977 2202380 2202380 defendant Gerberge Thomas   606482 606482 Gerberge, Thomas, of Norfolk, knight 1
4507566 2202828 2202828 defendant Thorp Edmund de merchant 606482 606482 Thorp, Edmund de, of Norfolk, merchant 0
4512334 2204297 2204297 defendant Person Thomas   606482 606482 Person, Thomas, of Norfolk 4
4521851 2207170 2207170 defendant Hastynges Edmund   606482 606482 Hastynges, Edmund, of Norfolk 0
4526194 2208481 2208481 defendant Lacche Thomas   606482 606482 Lacche, Thomas, of Norfolk 5
4529199 2209411 2209411 defendant Kirkestede John esq 606482 606482 Kirkestede, John, of Norfolk, esq 1
4529560 2209526 2209526 defendant Gerberge Thomas   606482 606482 Gerberge, Thomas, of Norfolk, knight 0
4536257 2211618 2211618 defendant Shanehede Henry   606482 606482 Shanehede, Henry, of Norfolk 0
4537132 2211885 2211885 defendant Toly John esq 606482 606482 Toly, John, of Norfolk, esq 2
4537138 2211886 2211886 defendant Toly John esq 606482 606482 Toly, John, of Norfolk, esq 2
4540576 2212953 2212953 defendant Munden Richard   606482 606482 Munden, Richard, of Norfolk 1
4541170 2213135 2213135 defendant Criston Leonard de   606482 606482 Criston, Leonard de, of Norfolk, knight 1
4541177 2213136 2213136 defendant Criston Leonard   606482 606482 Criston, Leonard, of Norfolk, knight 1
4542674 2213596 2213596 defendant Plomer Philip   606482 606482 Plomer, Philip, of Norfolk 0
4546522 2214843 2214843 defendant Symond John   606482 606482 Symond, John, of Norfolk 0
4546789 2214922 2214922 defendant Reps Robert   606482 606482 Reps, Robert, of Norfolk 0
4546790 2214922 2214922 defendant Reps John   606482 606482 Reps, John, of Norfolk 1
4550039 2215948 2215948 defendant Straunge John   606482 606482 Straunge, John, of Norfolk, knight 0
4551265 2216335 2216335 defendant Fote William   606482 606482 Fote, William, of Norfolk 2
4551485 2216404 2216404 defendant Northfolk Nicholas   606482 606482 Northfolk, Nicholas, of Norfolk 1
4553877 2217133 2217133 defendant Billyngford James   606482 606482 Billyngford, James, of Norfolk 6
4553886 2217134 2217134 defendant Billyngford James   606482 606482 Billyngford, James, of Norfolk 6
4555583 2217675 2217675 defendant Robekyn Robert   606482 606482 Robekyn, Robert, of Norfolk 0
4555930 2217793 2217793 defendant Mous Richard   606482 606482 Mous, Richard, of Norfolk 0
4556467 2217965 2217965 defendant Lane John   606482 606482 Lane, John, of Norfolk 0
4557613 2218315 2218315 defendant Bergh Geoffrey   606482 606482 Bergh, Geoffrey, of Norfolk 3
4557614 2218315 2218315 defendant Benale Robert   606482 606482 Benale, Robert, of Norfolk 4
4557978 2218429 2218429 plaintiff Leverich John   606482 606482 Leverich, John, of Norfolk 0
4562204 2219747 2219747 defendant Crispyng John   606482 606482 Crispyng, John, of Norfolk 0
4562207 2219748 2219748 defendant Crsipyng John   606482 606482 Crsipyng, John, of Norfolk 0
4562355 2219788 2219788 defendant Drewe Richard   606482 606482 Drewe, Richard, of Norfolk 0
4563726 2220225 2220225 defendant Shelford John   606482 606482 Shelford, John, of Norfolk 1
4563727 2220225 2220225 defendant Shelford Richard   606482 606482 Shelford, Richard, of Norfolk 2
4564079 2220337 2220337 defendant Northerne William   606482 606482 Northerne, William, of Norfolk 0
4564081 2220338 2220338 defendant Northerne William   606482 606482 Northerne, William, of Norfolk 0
4565691 2220835 2220835 defendant Mondeford John   606482 606482 Mondeford, John, of Norfolk 0
4566004 2220921 2220921 defendant Brusle Robert   606482 606482 Brusle, Robert, of Norfolk 0
4566008 2220922 2220922 defendant Brusle Robert   606482 606482 Brusle, Robert, of Norfolk 0
4566396 2221060 2221060 defendant Tabbe William   606482 606482 Tabbe, William, of Norfolk 0
4568073 2221582 2221582 defendant Thorp Robert de esq 606482 606482 Thorp, Robert de, of Norfolk, esq 3
4569976 2222179 2222179 defendant Weston John   606482 606482 Weston, John, of Norfolk 1
4573525 2223244 2223244 defendant Gerbrigge Thomas   606482 606482 Gerbrigge, Thomas, of Norfolk, knight 0
4573533 2223245 2223245 defendant Gerbrigge Thomas   606482 606482 Gerbrigge, Thomas, of Norfolk, knight 0
4573585 2223255 2223255 defendant Braunche Katherine   606482 606482 Braunche, Katherine, of Norfolk 3
4573591 2223256 2223256 defendant Spenser William   606482 606482 Spenser, William, of Norfolk 0
4574871 2223668 2223668 defendant Straunge John le   606482 606482 Straunge, John le, of Norfolk, knight 0
4575952 2223970 2223970 defendant Gote_ John   606482 606482 Gote_, John, of Norfolk 0
4576652 2224208 2224208 defendant Barkere John   606482 606482 Barkere, John, of Norfolk 0
4578422 2224738 2224738 defendant Salle John   606482 606482 Salle, John, of Norfolk 0
4579957 2225218 2225218 defendant Paulee John   606482 606482 Paulee, John, of Norfolk 1
4579972 2225223 2225223 defendant Panlee John   606482 606482 Panlee, John, of Norfolk 1
4581249 2225603 2225603 defendant Shelton William   606482 606482 Shelton, William, of Norfolk 0
4581444 2225663 2225663 defendant Hakebeche Robert esq 606482 606482 Hakebeche, Robert, of Norfolk, esq 2
4582547 2225984 2225984 defendant Charles Thomas   606482 606482 Charles, Thomas, of Norfolk, knight 6
4583867 2226370 2226370 defendant Barkere Nicholas   606482 606482 Barkere, Nicholas, of Norfolk 0
4585140 2226772 2226772 defendant Frend Thomas   606482 606482 Frend, Thomas, of Norfolk 0
4588025 2227652 2227652 defendant Inglose Henry   606482 606482 Inglose, Henry, of Norfolk 0
4588028 2227653 2227653 defendant Inglose Henry   606482 606482 Inglose, Henry, of Norfolk 0
4589365 2228050 2228050 defendant Bury John   606482 606482 Bury, John, of Norfolk 0
4590523 2228397 2228397 defendant Smyth Hugh   606482 606482 Smyth, Hugh, of Norfolk 0
4590524 2228397 2228397 defendant York John   606482 606482 York, John, of Norfolk 1
4590535 2228399 2228399 defendant Smyth Hugh   606482 606482 Smyth, Hugh, of Norfolk 0
4590536 2228399 2228399 defendant York John   606482 606482 York, John, of Norfolk 1
4591702 2228761 2228761 defendant Clere John esq 606482 606482 Clere, John, of Norfolk, esq 0
4591736 2228768 2228768 defendant Clere John esq 606482 606482 Clere, John, of Norfolk, esq 2
4591744 2228772 2228772 defendant Wychyngham Nicholas   606482 606482 Wychyngham, Nicholas, of Norfolk 0
4591746 2228773 2228773 defendant Wychyngham Nicholas   606482 606482 Wychyngham, Nicholas, of Norfolk 0
4591842 2228803 2228803 defendant Heryng John   606482 606482 Heryng, John, of Norfolk 1
4592710 2229060 2229060 defendant Shelton William   606482 606482 Shelton, William, of Norfolk 4
4592903 2229108 2229108 defendant Barry Edmund esq 606482 606482 Barry, Edmund, of Norfolk, esq 0

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