names

92 rows where place_id = 590335

✎ 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
3600683 1867863 1867863 defendant Stonewyll John husbandman 590335 590335 Stonewyll, John, of Kyngesbrygge, husbandman 0
3610750 1871028 1871028 defendant Chubbe William yeoman 590335 590335 Chubbe, William, of Kyngesbrygge, yeoman 0
3623714 1874950 1874950 defendant Rowe John tailor 590335 590335 Rowe, John, of Kyngesbrygge, tailor 0
3623715 1874950 1874950 defendant Waren William yeoman 590335 590335 Waren, William, of Kyngesbrygge, yeoman 1
3637545 1906554 1906554 defendant Smyth Richard merchant 590335 590335 Smyth, Richard, of Kyngesbrygge, merchant 0
3715464 1931123 1931123 defendant Taweley Robert merchant 590335 590335 Taweley, Robert, of Kyngesbrygge, merchant 0
3715465 1931123 1931123 defendant Bavell Robert merchant 590335 590335 Bavell, Robert, of Kyngesbrygge, merchant 1
3730937 1935906 1935906 defendant Taweley Robert merchant 590335 590335 Taweley, Robert, of Kyngesbrygge, merchant 0
3730938 1935906 1935906 defendant Babell Robert merchant 590335 590335 Babell, Robert, of Kyngesbrygge, merchant 1
3737280 1937896 1937896 defendant Hengston Richard husbandman 590335 590335 Hengston, Richard, of Kyngesbrygge, husbandman 2
3737281 1937896 1937896 defendant Goddefray William husbandman 590335 590335 Goddefray, William, of Kyngesbrygge, husbandman 3
3838844 1970075 1970075 defendant Legh Margery widow 590335 590335 Legh, Margery, of Kyngesbrygge, widow 0
3885845 1985522 1985522 plaintiff Bonfessor Andrew   590335 590335 Bonfessor, Andrew, of Kyngesbrygge 0
3885847 1985522 1985522 defendant Knyght John tanner 590335 590335 Knyght, John, of Kyngesbrygge, tanner 1
4620492 2237389 2237389 defendant Wilton John   590335 590335 Wilton, John, of Kyngesbrygge 2
4620498 2237390 2237390 defendant Wilton John   590335 590335 Wilton, John, of Kyngesbrygge 2
4634783 2241730 2241730 defendant Strange John   590335 590335 Strange, John, of Kyngesbrygge 0
4663286 2249987 2249987 defendant Orechard Thomas husbandman 590335 590335 Orechard, Thomas, of Kyngesbrygge, husbandman 0
4675197 2257855 2257855 defendant Coleford Stephen smith 590335 590335 Coleford, Stephen, of Kyngesbrygge, smith 0
4678272 2258811 2258811 defendant Blakhall Andrew chapman 590335 590335 Blakhall, Andrew, of Kyngesbrygge, chapman 0
4682331 2260098 2260098 defendant Kedlond Thomas fisher 590335 590335 Kedlond, Thomas, of Kyngesbrygge, fisher 3
4685489 2261056 2261056 defendant Coleford Stephen smith 590335 590335 Coleford, Stephen, of Kyngesbrygge, smith 0
4688832 2262063 2262063 plaintiff Torryng John   590335 590335 Torryng, John, of Kyngesbrygge, on his own account 0
4690982 2262704 2262704 defendant Pecok Hugh fuller 590335 590335 Pecok, Hugh, of Kyngesbrygge, fuller 0
4715043 2270031 2270031 defendant Radwale John hosier 590335 590335 Radwale, John, of Kyngesbrygge, hosier 2
4720529 2271758 2271758 plaintiff Brugge Walter merchant 590335 590335 Brugge, Walter, of Kyngesbrygge, merchant 0
4802191 2296875 2296875 defendant Saunder William weaver 590335 590335 Saunder, William, of Kyngesbrygge, weaver 1
4813104 2300215 2300215 defendant Whytyng William shoemaker 590335 590335 Whytyng, William, of Kyngesbrygge, shoemaker 0
4817653 2301609 2301609 defendant Vele John merchant 590335 590335 Vele, John, of Kyngesbrygge, merchant 0
4829263 2305191 2305191 defendant Mey John carpenter 590335 590335 Mey, John, of Kyngesbrygge, carpenter 3
4843405 2309453 2309453 defendant Lokynton Richard yeoman 590335 590335 Lokynton, Richard, of Kyngesbrygge, yeoman 1
4888005 2323056 2323056 plaintiff Fort Robert mariner 590335 590335 Fort, Robert, of Kyngesbrygge, mariner 0
4890280 2323730 2323730 defendant Blakhall Andrew mercer 590335 590335 Blakhall, Andrew, of Kyngesbrygge, mercer 0
4909071 2329378 2329378 defendant Maleburgh John butcher 590335 590335 Maleburgh, John, of Kyngesbrygge, butcher 0
4942281 2339579 2339579 defendant Lange John glover 590335 590335 Lange, John, of Kyngesbrygge, glover 2
4956646 2343945 2343945 defendant Kyrtell John glover 590335 590335 Kyrtell, John, of Kyngesbrygge, glover 1
5021721 2363249 2363249 defendant Honyford Richard   590335 590335 Honyford, Richard, of Kyngesbrygge, holy water clerk 4
5023020 2363642 2363642 defendant Vele John merchant 590335 590335 Vele, John, of Kyngesbrygge, merchant 0
5032637 2366430 2366430 defendant Stephyn Richard   590335 590335 Stephyn, Richard, of Kyngesbrygge, holy water clerk 0
5082598 2381302 2381302 defendant Stonewell John yeoman 590335 590335 Stonewell, John, of Kyngesbrygge, yeoman 0
5082609 2381304 2381304 defendant Stonewell John yeoman 590335 590335 Stonewell, John, of Kyngesbrygge, yeoman 0
5083758 2381645 2381645 defendant Olyver William weaver 590335 590335 Olyver, William, of Kyngesbrygge, weaver 0
5083759 2381645 2381645 defendant Steven Richard   590335 590335 Steven,Richard, of Kyngesbrygge, pedlar 1
5083760 2381645 2381645 defendant Wallyng John tailor 590335 590335 Wallyng, John, of Kyngesbrygge, tailor 2
5083762 2381645 2381645 defendant Cowele Andrew shoemaker 590335 590335 Cowele, Andrew, of Kyngesbrygge, shoemaker 4
5084750 2381947 2381947 defendant Wilberdon John, senior merchant 590335 590335 Wilberdon, John, senior, of Kyngesbrygge, merchant 0
5084751 2381947 2381947 defendant Wilberdon John, junior merchant 590335 590335 Wilberdon, John, junior, of Kyngesbrygge, merchant 1
5093989 2384640 2384640 defendant Warberton John   590335 590335 Warberton, John, of Kyngesbrygge, pedlar 0
5093990 2384640 2384640 defendant Warberton John, senior merchant 590335 590335 Warberton, John, senior, of Kyngesbrygge, merchant 1
5093991 2384640 2384640 defendant Warberton John, junior merchant 590335 590335 Warberton, John, junior, of Kyngesbrygge, merchant 2
5098748 2386062 2386062 defendant Olyver William weaver 590335 590335 Olyver, William, of Kyngesbrygge, weaver 0
5103895 2387565 2387565 defendant Olyver Thomas draper 590335 590335 Olyver, Thomas, of Kyngesbrygge, draper 0
5111541 2389772 2389772 defendant Rogger Robert   590335 590335 Rogger, Robert, of Kyngesbrygge, bailiff 1
5114108 2390522 2390522 defendant Smyth John mariner 590335 590335 Smyth, John, of Kyngesbrygge, mariner 0
5124021 2393481 2393481 defendant Franke Richard merchant 590335 590335 Franke, Richard, of Kyngesbrygge, merchant 0
5134568 2396601 2396601 defendant Mathewe Thomas butcher 590335 590335 (Mathewe, Thomas, of Kyngesbrygge, butcher 8
5134757 2396665 2396665 defendant Lydston Thomas husbandman 590335 590335 Lydston, Thomas, of Kyngesbrygge, husbandman 1
5154324 2402422 2402422 defendant Daunden John yeoman 590335 590335 Daunden, John, of Kyngesbrygge, yeoman 0
5154325 2402422 2402422 defendant Rogger Robert yeoman 590335 590335 Rogger, Robert, of Kyngesbrygge, yeoman 1
5166882 2406043 2406043 defendant Mathewe Thomas drover 590335 590335 Mathewe, Thomas, of Kyngesbrygge, drover 0
5213039 2419551 2419551 defendant Wylcokke John husbandman 590335 590335 Wylcokke, John, of Kyngesbrygge, husbandman 1
5214560 2419987 2419987 defendant Warberton John, junior soaper 590335 590335 Warberton, John, junior, of Kyngesbrygge, soaper 0
5226038 2423284 2423284 defendant Bowey John weaver 590335 590335 Bowey, John, of Kyngesbrygge, weaver 0
5226040 2423285 2423285 defendant Bowey John weaver 590335 590335 Bowey, John, of Kyngesbrygge, weaver 0
5234100 2425566 2425566 defendant Carswell William, junior mercer 590335 590335 (Carswell, William, junior, of Kyngesbrygge, mercer 1
5234308 2425622 2425622 defendant Wakeham Richard yeoman 590335 590335 Wakeham, Richard, of Kyngesbrygge, yeoman 0
5259584 2433117 2433117 defendant Warberton John, junior merchant 590335 590335 Warberton, John, junior, of Kyngesbrygge, merchant 3
5281311 2439607 2439607 defendant Philipp Thomas yeoman 590335 590335 Philipp, Thomas, of Kyngesbrygge, yeoman 0
5287572 2441391 2441391 defendant Gyldon Simon barber 590335 590335 Gyldon, Simon, of Kyngesbrygge, barber 0
5287574 2441391 2441391 defendant Shynner Robert   590335 590335 Shynner, Robert, of Kyngesbrygge, franklin 2
5299052 2444704 2444704 defendant Assheley Henry mercer 590335 590335 Assheley, Henry, of Kyngesbrygge, mercer 0
5333547 2455107 2455107 defendant Chubbe William yeoman 590335 590335 Chubbe, William, of Kyngesbrygge, yeoman 0
5333548 2455107 2455107 defendant Prefote David yeoman 590335 590335 together with Prefote, David, of Kyngesbrygge, yeoman 1
5333549 2455107 2455107 defendant Sayer John yeoman 590335 590335 Sayer, John, of Kyngesbrygge, yeoman 2
5333550 2455107 2455107 defendant Yoman William laborer 590335 590335 Yoman, William, of Kyngesbrygge, laborer 3
5333551 2455107 2455107 defendant Leme John yeoman 590335 590335 Leme, John, of Kyngesbrygge, yeoman 4
5338044 2456467 2456467 defendant Mathewe Walter yeoman 590335 590335 Mathewe, Walter, of Kyngesbrygge, yeoman 0
5342844 2457956 2457956 defendant Sayer John baker 590335 590335 Sayer, John, of Kyngesbrygge, baker 1
5349553 2459990 2459990 defendant Yonge Robert smith 590335 590335 Yonge, Robert, of Kyngesbrygge, smith 0
5349555 2459991 2459991 defendant Yonge Robert smith 590335 590335 Yonge, Robert, of Kyngesbrygge, smith 0
5386420 2471187 2471187 defendant Serle John laborer 590335 590335 Serle, John, of Kyngesbrygge, laborer 1
5392973 2473060 2473060 defendant Spycer William yeoman 590335 590335 Spycer, William, of Kyngesbrygge, yeoman 1
5406107 2476822 2476822 defendant Spycer William yeoman 590335 590335 Spycer, William, of Kyngesbrygge, yeoman 1
5443194 2487879 2487879 defendant Rogger John weaver 590335 590335 Rogger, John, of Kyngesbrygge, weaver 0
5480215 2499065 2499065 defendant Thonger William cordwainer 590335 590335 Thonger, William, of Kyngesbrygge, cordwainer 0
5480216 2499065 2499065 defendant Wynter Stephen smith 590335 590335 Wynter, Stephen, of Kyngesbrygge, smith 1
5530297 2513986 2513986 defendant Northwyche Henry glover 590335 590335 Northwyche, Henry, of Kyngesbrygge, glover 0
5583769 2529998 2529998 defendant Lambe James merchant 590335 590335 Lambe, James, of Kyngesbrygge, merchant 0
5591668 2532377 2532377 defendant Perret John weaver 590335 590335 Perret, John, of Kyngesbrygge, weaver 0
5592176 2532548 2532548 defendant Lambe John merchant 590335 590335 Lambe, John, of Kyngesbrygge, merchant 0
5630252 2553468 2553468 defendant Sourdecote Thomas draper 590335 590335 Sourdecote, Thomas, of Kyngesbrygge, draper 0
5635530 2555075 2555075 defendant Combe John husbandman 590335 590335 Combe, John, of Kyngesbrygge, husbandman 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);