names

76 rows where place_id = 590976

✎ 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
3602875 1868566 1868566 defendant Clerk Thomas carrier 590976 590976 Clerk, Thomas, of Maunsfeld, carrier 1
3630726 1904435 1904435 plaintiff Flogan Cecilia widow 590976 590976 Flogan, Cecilia, of Maunsfeld, widow 0
3630732 1904436 1904436 plaintiff Flogan Cecily widow 590976 590976 Flogan, Cecily, of Maunsfeld, widow 0
3630735 1904437 1904437 plaintiff Flogan Cecily widow 590976 590976 Flogan, Cecily, of Maunsfeld, widow 0
3636476 1906200 1906200 defendant Gladwen Robert carpenter 590976 590976 Gladwen, Robert, of Maunsfeld, carpenter 0
3641342 1907745 1907745 defendant Gladwyn Thomas carpenter 590976 590976 (Gladwyn, Thomas, of Maunsfeld, carpenter 1
3641343 1907745 1907745 defendant Gladwyn Hugh husbandman 590976 590976 Gladwyn, Hugh, of Maunsfeld, husbandman 2
3641344 1907745 1907745 defendant Gladwyn Beatrice widow 590976 590976 Gladwyn, Beatrice, of Maunsfeld, widow 3
3680290 1919911 1919911 defendant Lauraunce Thomas   590976 590976 Lauraunce, Thomas, of Maunsfeld, rough mason 0
3680297 1919914 1919914 defendant Sylvester Otwell fishmonger 590976 590976 Sylvester, Otwell, of Maunsfeld, fishmonger 1
3954412 2008612 2008612 defendant Wylde William innholder 590976 590976 Wylde, William, of Maunsfeld, innholder 0
3954413 2008612 2008612 defendant Revell William innholder 590976 590976 Revell, William, of Maunsfeld, innholder 1
3983727 2018952 2018952 defendant Revell John gent 590976 590976 Revell, John, of Maunsfeld, gent 0
3992646 2022118 2022118 plaintiff Butler James painter or pewterer 590976 590976 Butler, James, of Maunsfeld, painter or pewterer 0
3992647 2022118 2022118 defendant Herynge John husbandman 590976 590976 Herynge, John, of Maunsfeld, husbandman 0
4189991 2092002 2092002 defendant Ludlam John chapman 590976 590976 Ludlam, John, of Maunsfeld, chapman 0
4238326 2109015 2109015 defendant Shutt Richard   590976 590976 Shutt, Richard, of Maunsfeld, Notts glover 1
4541547 2213251 2213251 defendant Barker William   590976 590976 together with Barker, William, of Maunsfeld 1
4556249 2217894 2217894 defendant Randolf John   590976 590976 Randolf, John, of Maunsfeld, vicar 0
4564333 2220415 2220415 plaintiff Sandeacre Richard de   590976 590976 Sandeacre, Richard de, of Maunsfeld 0
4664849 2250484 2250484 defendant Fossebroke Nicholas cordwainer 590976 590976 Fossebroke, Nicholas, of Maunsfeld, cordwainer 2
4669002 2256010 2256010 defendant Couper Thomas husbandman 590976 590976 Couper, Thomas, of Maunsfeld, husbandman 0
4669003 2256010 2256010 defendant Stacy Thomas husbandman 590976 590976 Stacy, Thomas, of Maunsfeld, husbandman 1
4685516 2261064 2261064 defendant Fosbroke Roger shoemaker 590976 590976 Fosbroke, Roger, of Maunsfeld, shoemaker 2
4779978 2289739 2289739 defendant Selston Richard yeoman 590976 590976 Selston, Richard, of Maunsfeld, yeoman 0
4782895 2290669 2290669 defendant Selston Richard yeoman 590976 590976 (Selston, Richard, of Maunsfeld, yeoman 1
4782899 2290670 2290670 defendant Selston Richard yeoman 590976 590976 (Selston, Richard, of Maunsfeld, yeoman 1
4791543 2293449 2293449 defendant Walker Henry husbandman 590976 590976 Walker, Henry, of Maunsfeld, husbandman 0
4794230 2294333 2294333 defendant Innocent Robert husbandman 590976 590976 Innocent, Robert, of Maunsfeld, husbandman 1
4800896 2296467 2296467 defendant Selleston Richard husbandman 590976 590976 Selleston, Richard, of Maunsfeld, husbandman 1
4861958 2315119 2315119 defendant Martyn Richard husbandman 590976 590976 Martyn, Richard, of Maunsfeld, husbandman 0
4868546 2317137 2317137 defendant Martyn Richard   590976 590976 Martyn, Richard, of Maunsfeld, cartwright 0
4869378 2317391 2317391 defendant Sutton Richard husbandman 590976 590976 Sutton, Richard, of Maunsfeld, husbandman 2
4878519 2320226 2320226 defendant de Asshe John saddler 590976 590976 de Asshe, John, of Maunsfeld, saddler 0
4905344 2328263 2328263 defendant Walker Thomas husbandman 590976 590976 Walker, Thomas, of Maunsfeld, husbandman 0
4905345 2328263 2328263 defendant Walker Henry husbandman 590976 590976 Walker, Henry, of Maunsfeld, husbandman 1
4905346 2328263 2328263 defendant Walker thomas, junior husbandman 590976 590976 Walker, thomas, junior, of Maunsfeld, husbandman 2
4938971 2338581 2338581 defendant Hodeley John yeoman 590976 590976 Hodeley, John, of Maunsfeld, yeoman 0
4951742 2342497 2342497 defendant Sutton Thomas yeoman 590976 590976 Sutton, Thomas, of Maunsfeld, yeoman 0
5006955 2358933 2358933 defendant Sutton William husbandman 590976 590976 Sutton, William, of Maunsfeld, husbandman 3
5010337 2359892 2359892 defendant Suker John tanner 590976 590976 Suker, John, of Maunsfeld, tanner 2
5029258 2365436 2365436 defendant Hynkershall John slater 590976 590976 Hynkershall, John, of Maunsfeld, slater 1
5030507 2365793 2365793 defendant Padley Nicholas yeoman 590976 590976 Padley, Nicholas, of Maunsfeld, yeoman 1
5094912 2384926 2384926 defendant Lenton Stephen   590976 590976 Lenton, Stephen, of Maunsfeld 0
5097284 2385637 2385637 defendant Robert John husbandman or laborer 590976 590976 Robert, John, of Maunsfeld, husbandman or laborer 0
5104923 2387876 2387876 defendant Watson Richard butcher 590976 590976 Watson, Richard, of Maunsfeld, butcher 0
5274496 2437620 2437620 defendant Hynkersell Robert   590976 590976 Hynkersell, Robert, of Maunsfeld, wright 0
5274497 2437620 2437620 defendant Hall John husbandman 590976 590976 Hall, John, of Maunsfeld, husbandman 1
5274499 2437620 2437620 defendant Walker William   590976 590976 Walker, William, of Maunsfeld husbandman 3
5274500 2437620 2437620 defendant Walker John husbandman 590976 590976 Walker, John, of Maunsfeld, husbandman 4
5274502 2437620 2437620 defendant Barker Robert tanner 590976 590976 Barker, Robert, of Maunsfeld, tanner 6
5274503 2437620 2437620 defendant Botery John slater 590976 590976 Botery, John, of Maunsfeld, slater 7
5274504 2437620 2437620 defendant Walker Henry, junior yeoman 590976 590976 Walker, Henry, junior, of Maunsfeld, yeoman 8
5285421 2440758 2440758 defendant Wellemote Thomas barber 590976 590976 Wellemote, Thomas, of Maunsfeld, barber 1
5290243 2442148 2442148 defendant Barry Robert barker 590976 590976 Barry, Robert, of Maunsfeld, barker 0
5290244 2442148 2442148 defendant Clerk Robert yeoman 590976 590976 Clerk, Robert, of Maunsfeld, yeoman 1
5290246 2442149 2442149 defendant Barry Robert barker 590976 590976 Barry, Robert, of Maunsfeld, barker 0
5290247 2442149 2442149 defendant Clerk Robert yeoman 590976 590976 Clerk, Robert, of Maunsfeld, yeoman 1
5291274 2442453 2442453 defendant Hynkersew or Hynkersell Robert   590976 590976 Hynkersew or Hynkersell, Robert, of Maunsfeld, wright 0
5291275 2442453 2442453 defendant Hall John husbandman 590976 590976 Hall, John, of Maunsfeld, husbandman 1
5291276 2442453 2442453 defendant Walker Henry, senior husbandman 590976 590976 Walker, Henry, senior, of Maunsfeld, husbandman 2
5291277 2442453 2442453 defendant Walker William husbandman 590976 590976 Walker, William, of Maunsfeld, husbandman 3
5291278 2442453 2442453 defendant Walker John husbandman 590976 590976 Walker, John, of Maunsfeld, husbandman 4
5291279 2442453 2442453 defendant Smyth John smith 590976 590976 Smyth, John, of Maunsfeld, smith 5
5291280 2442453 2442453 defendant Barker Robert barker 590976 590976 Barker, Robert, of Maunsfeld, barker 6
5291281 2442453 2442453 defendant Botery John slater 590976 590976 Botery, John, of Maunsfeld, slater 7
5291282 2442453 2442453 defendant Walker Henry, junior yeoman 590976 590976 Walker, Henry, junior, of Maunsfeld, yeoman 8
5350100 2460157 2460157 defendant Molde John yeoman 590976 590976 Molde, John, of Maunsfeld, yeoman 0
5396178 2473995 2473995 plaintiff Beverege Robert   590976 590976 Beverege, Robert, of Maunsfeld 0
5409530 2477816 2477816 plaintiff Beverege Robert   590976 590976 Beverege, Robert, of Maunsfeld 0
5409533 2477816 2477816 defendant Burton John tanner 590976 590976 Burton, John, of Maunsfeld, tanner 2
5500589 2505112 2505112 defendant Colynson Thomas tailor 590976 590976 Colynson, Thomas, of Maunsfeld, tailor 4
5502391 2505671 2505671 defendant Welley Robert butcher 590976 590976 Welley, Robert, of Maunsfeld, butcher 0
5502392 2505671 2505671 defendant Clerk John butcher 590976 590976 Clerk, John, of Maunsfeld, butcher 1
5581482 2529279 2529279 defendant Copley Henry chaplain 590976 590976 Copley, Henry, of Maunsfeld, chaplain 0
5583149 2529803 2529803 defendant Blakwall George gent 590976 590976 Blakwall, George, of Maunsfeld, gent 1

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