names

204 rows where place_id = 589999

✎ 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
3599527 1867491 1867491 plaintiff Tygo John draper 589999 589999 Tygo, John, of Lenn, draper 0
3599528 1867491 1867491 defendant Bay John merchant 589999 589999 Bay, John, of Lenn, merchant 0
3599529 1867492 1867492 plaintiff Tygo John draper 589999 589999 Tygo, John, of Lenn, draper 0
3599530 1867492 1867492 defendant Sperke John smith 589999 589999 Sperke, John, of Lenn, smith 0
3624518 1875205 1875205 plaintiff Torisby Thomas merchant 589999 589999 Torisby, Thomas, of Lenn, merchant 0
3626433 1903123 1903123 plaintiff Awmfles Richard (legal representative) 589999 589999 Awmfles, Richard, of Lenn, merchant, executor of 0
3647768 1909695 1909695 plaintiff Marche William (legal representative) 589999 589999 Marche, William, of Lenn, executor of 0
3701435 1926693 1926693 defendant Keyode William husbandman 589999 589999 Keyode, William, of Lenn St Peter, husbandman 3
3711750 1929988 1929988 defendant Kyrby Thomas merchant 589999 589999 Kyrby, Thomas, of Lenn, merchant 0
3714760 1930918 1930918 defendant Gryggys William husbandman 589999 589999 Gryggys, William, of Lenn, husbandman 3
3721138 1932909 1932909 plaintiff Kyrkeby William haberdasher 589999 589999 Kyrkeby, William, of Lenn, haberdasher 0
3761725 1945677 1945677 plaintiff Flete Thomas gent 589999 589999 Flete, Thomas, of Lenn, gent 0
3856939 1975800 1975800 plaintiff Adam William   589999 589999 Adam, William, of Lenn 0
3872332 1980970 1980970 defendant Broun John (legal representative) 589999 589999 Broun, John, of Lenn, executors of 0
3883823 1984857 1984857 plaintiff Whyte Thomas (legal representative) 589999 589999 Whyte, Thomas, of Lenn, executors of 0
4417035 2170201 2170201 plaintiff Pulter Hugh   589999 589999 Pulter, Hugh, of Lenn 0
4418223 2170584 2170584 defendant Belleyetere Thomas   589999 589999 Belleyetere, Thomas, of Lenn 0
4419576 2171008 2171008 plaintiff Belleyeter Edmund   589999 589999 Belleyeter, Edmund, of Lenn 0
4420357 2171270 2171270 defendant Snoryngg William de merchant 589999 589999 Snoryngg, William de, of Lenn, merchant 0
4420580 2171340 2171340 defendant Yaxham John de   589999 589999 Yaxham, John de, of Lenn, burgess, son of Richard 0
4421338 2171576 2171576 plaintiff Cokes Thomas   589999 589999 Cokes, Thomas, of Lenn 0
4421993 2171758 2171758 defendant Peynot Thomas   589999 589999 Peynot, Thomas, of Lenn, burgess 0
4423733 2172267 2172267 plaintiff Haret Geoffrey   589999 589999 Haret, Geoffrey, of Lenn 0
4424668 2172555 2172555 defendant Dockynge Richard de   589999 589999 Dockynge, Richard de, of Lenn 1
4427251 2173355 2173355 defendant Northhill William de   589999 589999 Northhill, William de, of Lenn 0
4427252 2173355 2173355 defendant Bennok Geoffrey   589999 589999 together with Bennok, Geoffrey, of Lenn 1
4429791 2174100 2174100 defendant atte Fen John   589999 589999 atte Fen, John, of Lenn 0
4432696 2174978 2174978 defendant Peynot Thomas   589999 589999 Peynot, Thomas, of Lenn, burgess 0
4432699 2174979 2174979 defendant Paynot Thomas   589999 589999 Paynot, Thomas, of Lenn, burgess 1
4434990 2175706 2175706 defendant Chalton Robert de   589999 589999 Chalton, Robert de, of Lenn 0
4434994 2175707 2175707 defendant Chalton Robert   589999 589999 Chalton, Robert, of Lenn 0
4435579 2175889 2175889 defendant Snoryngg William de   589999 589999 Snoryngg, William de, of Lenn, burgess 0
4441584 2182303 2182303 plaintiff Bowyer Richard   589999 589999 Bowyer, Richard, of Lenn 0
4441585 2182303 2182303 plaintiff Baron William   589999 589999 Baron, William, of Lenn 1
4441587 2182304 2182304 plaintiff Bowyer Richard   589999 589999 Bowyer, Richard, of Lenn 0
4441588 2182304 2182304 plaintiff Baroun William   589999 589999 Baroun, William, of Lenn 1
4442443 2182582 2182582 plaintiff Bucham William merchant 589999 589999 Bucham, William, of Lenn, merchant, on his own account 0
4448746 2184545 2184545 plaintiff Furbour Richard   589999 589999 Furbour, Richard, of Lenn 0
4448748 2184546 2184546 plaintiff Furbour Richard   589999 589999 Furbour, Richard, of Lenn 0
4449018 2184636 2184636 plaintiff Gedeney Simon de   589999 589999 Gedeney, Simon de, of Lenn, burgess 0
4451517 2185445 2185445 defendant Hunte Alan   589999 589999 Hunte, Alan, of Lenn 0
4454211 2186333 2186333 plaintiff Lucas John   589999 589999 Lucas, John, of Lenn 0
4456031 2186909 2186909 plaintiff Narford Nicholas   589999 589999 Narford, Nicholas, of Lenn 0
4456881 2187163 2187163 plaintiff Owylite John   589999 589999 Owylite, John, of Lenn, burgess 0
4456958 2187185 2187185 plaintiff Pakenham Thomas   589999 589999 Pakenham, Thomas, of Lenn, burgess 0
4457338 2187310 2187310 plaintiff Penteney Adam merchant 589999 589999 Penteney, Adam, of Lenn, merchant 0
4457344 2187310 2187310 defendant Braycrop John   589999 589999 Braycrop, John, of Lenn, burgess 5
4459033 2187869 2187869 defendant Salman William   589999 589999 Salman, William, of Lenn 0
4463614 2189317 2189317 defendant Walden Robert   589999 589999 Walden, Robert, of Lenn 0
4463616 2189318 2189318 defendant Waterden Richard   589999 589999 Waterden, Richard, of Lenn 0
4463618 2189319 2189319 defendant Waterden Robert   589999 589999 Waterden, Robert, of Lenn 0
4478471 2193942 2193942 plaintiff Hert John   589999 589999 Hert, John, of Lenn, on his own account 0
4478476 2193943 2193943 plaintiff Hert John   589999 589999 Hert, John, of Lenn, on his own account 0
4482186 2195138 2195138 defendant Gardener Robert   589999 589999 Gardener, Robert, of Lenn 2
4484962 2195996 2195996 plaintiff Prentys John   589999 589999 Prentys, John, of Lenn, burgess 0
4488244 2197040 2197040 defendant Bynle William   589999 589999 Bynle, William, of Lenn 1
4491331 2197976 2197976 defendant Foldyk John   589999 589999 Foldyk, John, of Lenn 2
4495750 2199355 2199355 plaintiff Creyk John   589999 589999 (Creyk, John, of Lenn 1
4497582 2199889 2199889 plaintiff Drewe Thomas   589999 589999 Drewe, Thomas, of Lenn, burgess 0
4498932 2200305 2200305 plaintiff Detryngge William de chaplain & sacristan of St Margaret's church 589999 589999 Detryngge, William de, of Lenn, chaplain & sacristan of St Margaret's church 1
4502062 2201242 2201242 plaintiff Masey John   589999 589999 Masey, John, of Lenn, on his own account 0
4503885 2201777 2201777 plaintiff Prentys John   589999 589999 Prentys, John, of Lenn, burgess, on his own account 0
4507336 2202759 2202759 plaintiff Waterden Robert   589999 589999 Waterden, Robert, of Lenn, burgess 0
4511262 2203970 2203970 defendant Maynard John   589999 589999 Maynard, John, of Lenn 0
4512832 2204446 2204446 plaintiff Brandon John   589999 589999 Brandon, John, of Lenn 0
4512836 2204447 2204447 plaintiff Brandon John   589999 589999 Brandon, John, of Lenn 0
4513677 2204705 2204705 defendant Stoke Robert   589999 589999 Stoke, Robert, of Lenn 8
4518811 2206251 2206251 defendant Knapton John   589999 589999 Knapton, John, of Lenn 6
4518823 2206252 2206252 defendant Knapton John   589999 589999 Knapton, John, of Lenn 6
4520388 2206720 2206720 defendant Lonway Godfrey chapman 589999 589999 Lonway, Godfrey, of Lenn, chapman 1
4524191 2207899 2207899 defendant Lynstheles William merchant 589999 589999 Lynstheles, William, of Lenn, merchant 0
4528553 2209206 2209206 plaintiff Masey John   589999 589999 Masey, John, of Lenn 0
4546167 2214748 2214748 plaintiff Brandone John   589999 589999 Brandone, John, of Lenn, burgess 0
4548779 2215554 2215554 defendant Lakynghythe Alan   589999 589999 Lakynghythe, Alan, of Lenn 0
4560697 2219294 2219294 defendant Clyppeston Robert smith 589999 589999 Clyppeston, Robert, of Lenn, smith 0
4561530 2219542 2219542 plaintiff Paynot Thomas   589999 589999 Paynot, Thomas, of Lenn, son of Simon 0
4567753 2221479 2221479 plaintiff Tolbothe Richard   589999 589999 Tolbothe, Richard, of Lenn, burgess 0
4570564 2222368 2222368 plaintiff Wych William   589999 589999 Wych, William, of Lenn 0
4571346 2222623 2222623 defendant Sysden Thomas   589999 589999 Sysden, Thomas, of Lenn, brass worker 0
4572719 2223006 2223006 defendant Yerlle John   589999 589999 Yerlle, John, of Lenn 3
4573375 2223205 2223205 plaintiff Baret William   589999 589999 Baret, William, of Lenn, burgess & merchant 0
4578479 2224758 2224758 plaintiff Cleye William barber 589999 589999 Cleye, William, of Lenn, barber 0
4581108 2225576 2225576 plaintiff Draper John   589999 589999 Draper, John, of Lenn, burgess & merchant 0
4594519 2229543 2229543 defendant Thwayt Richard   589999 589999 Thwayt, Richard, of Lenn, burgess 0
4600051 2231242 2231242 defendant Hostiller William   589999 589999 Hostiller, William, of Lenn 3
4600328 2231331 2231331 defendant Pynder Roger butcher 589999 589999 Pynder, Roger, of Lenn, butcher 0
4600557 2231397 2231397 defendant Millere Thomas   589999 589999 Millere, Thomas, of Lenn 1
4600558 2231397 2231397 defendant Bocher Hamond   589999 589999 Bocher, Hamond, of Lenn 2
4600559 2231397 2231397 defendant Hode Roger   589999 589999 Hode, Roger, of Lenn 3
4604793 2232666 2232666 plaintiff Abnale Thomas   589999 589999 Abnale, Thomas, of Lenn, burgess 0
4607211 2233371 2233371 plaintiff Bedyngham Ralph de   589999 589999 Bedyngham, Ralph de, of Lenn, burgess 0
4607352 2233407 2233407 plaintiff Belleyetere Edmund   589999 589999 Belleyetere, Edmund, of Lenn, burgess & merchant 0
4607718 2233522 2233522 plaintiff Bircham William   589999 589999 Bircham, William, of Lenn 0
4608885 2233882 2233882 plaintiff Bricham William   589999 589999 Bricham, William, of Lenn, burgess & merchant 0
4609327 2234018 2234018 defendant Utlawe Nicholas   589999 589999 Utlawe, Nicholas, of Lenn 1
4614208 2235455 2235455 defendant Thweyt Richard   589999 589999 Thweyt, Richard, of Lenn, burgess & merchant 0
4614210 2235456 2235456 defendant Thweyte Richard de   589999 589999 Thweyte, Richard de, of Lenn, burgess & merchant 0
4614236 2235464 2235464 defendant Whilteshire William   589999 589999 Whilteshire, William, of Lenn 2
4614241 2235466 2235466 plaintiff Draper John   589999 589999 Draper, John, of Lenn, burgess 0
4615165 2235750 2235750 defendant Waterman Edmund   589999 589999 Waterman, Edmund, of Lenn 3

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