names

54 rows where place_id = 610400

✎ 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
3683352 1920917 1920917 defendant Cadbery Richard husbandman 610400 610400 (Cadbery, Richard, of Milford, husbandman 2
3693050 1924033 1924033 defendant Trocher John husbandman 610400 610400 Trocher, John, of Milford, husbandman 0
3707192 1928540 1928540 defendant Trocher John husbandman 610400 610400 Trocher, John, of Milford, husbandman 0
3712728 1930296 1930296 defendant Lethom Robert husbandman 610400 610400 Lethom, Robert, of Milford, husbandman 0
4081377 2053646 2053646 defendant Rowe Henry yeoman 610400 610400 Rowe, Henry, of Milford, yeoman 0
4224209 2103955 2103955 defendant Hamond William gent 610400 610400 Hamond, William, of Milford, gent 0
4264728 2117845 2117845 defendant Hamond William gent 610400 610400 Hamond, William, of Milford, gent 0
4463320 2189220 2189220 plaintiff Bolton Roger de   610400 610400 Bolton, Roger de, of Milford 1
4485175 2196065 2196065 defendant Wale Peter   610400 610400 Wale, Peter, of Milford 0
4519630 2206500 2206500 defendant Sare Richard   610400 610400 Sare, Richard, of Milford 0
4534689 2211124 2211124 defendant Shorham Robert   610400 610400 Shorham, Robert, of Milford 0
4537674 2212055 2212055 defendant Batman John fuller 610400 610400 Batman, John, of Milford, fuller 1
4546170 2214748 2214748 defendant Fenne Thomas   610400 610400 Fenne, Thomas, of Milford 2
4560738 2219309 2219309 defendant Tagge Robert   610400 610400 Tagge, Robert, of Milford 0
4562586 2219857 2219857 defendant Heyng Petronella   610400 610400 Heyng, Petronella, of Milford 2
4575438 2223830 2223830 defendant Stebbe John   610400 610400 Stebbe, John, of Milford 0
4602293 2231933 2231933 plaintiff Webbe John   610400 610400 Webbe, John, of Milford 0
4602294 2231933 2231933 defendant Webbe Alexander   610400 610400 Webbe, Alexander, of Milford 0
4704270 2266712 2266712 defendant Buntynge John husbandman 610400 610400 Buntynge, John, of Milford, husbandman 1
4786882 2291957 2291957 defendant Bonevyll Thomas laborer 610400 610400 Bonevyll, Thomas, of Milford, laborer 0
4816510 2301255 2301255 defendant Sclatter John slatter 610400 610400 Sclatter, John, of Milford, slatter 1
4840358 2308529 2308529 defendant Norman John tailor 610400 610400 Norman, John, of Milford, tailor 0
4850420 2311588 2311588 defendant Deere Thomas butcher 610400 610400 Deere, Thomas, of Milford, butcher 1
4858339 2313980 2313980 defendant Caleys Nicholas husbandman 610400 610400 Caleys, Nicholas, of Milford, husbandman 2
4871925 2318196 2318196 defendant Bulle William husbandman 610400 610400 Bulle, William, of Milford, husbandman 0
4892150 2324287 2324287 defendant Bythewode John carter 610400 610400 Bythewode, John, of Milford, carter 0
4901446 2327058 2327058 defendant Meux John yeoman 610400 610400 Meux, John, of Milford, yeoman 5
4987458 2353205 2353205 defendant Goldesburgh William husbandman 610400 610400 Goldesburgh, William, of Milford, husbandman 0
4987459 2353205 2353205 defendant Proppe John husbandman 610400 610400 Proppe, John, of Milford, husbandman 1
4987460 2353205 2353205 defendant Ben John husbandman 610400 610400 Ben, John, of Milford, husbandman 2
5097603 2385727 2385727 defendant Fyleskirk Guy husbandman 610400 610400 Fyleskirk, Guy, of Milford, husbandman 0
5099327 2386233 2386233 defendant Tomson Thomas husbandman 610400 610400 Tomson, Thomas, of Milford, husbandman 1
5142278 2398860 2398860 defendant Spencer Robert   610400 610400 Spencer, Robert, of Milford, vicar 0
5142280 2398860 2398860 defendant Clerk William husbandman 610400 610400 Clerk, William, of Milford, husbandman 2
5163521 2405061 2405061 defendant (not given) Robert vicar of Spencer 610400 610400 Spencer, Robert, of Milford, vicar of the parish church 0
5163523 2405061 2405061 defendant Clerk William husbandman 610400 610400 Clerk, William, of Milford, husbandman 2
5200360 2415867 2415867 defendant Proppe Thomas husbandman 610400 610400 Proppe, Thomas, of Milford, husbandman 0
5200361 2415867 2415867 defendant Bothe William husbandman 610400 610400 Bothe, William, of Milford, husbandman 1
5201007 2416052 2416052 defendant Chilche John husbandman 610400 610400 Chilche, John, of Milford, husbandman 2
5223660 2422606 2422606 defendant Mirfeld Walter miller 610400 610400 Mirfeld, Walter,of Milford, miller 0
5372954 2467132 2467132 defendant Broun John husbandman 610400 610400 Broun, John, of Milford, husbandman 0
5388518 2471769 2471769 defendant Br_ John husbandman 610400 610400 Br_, John, of Milford, husbandman 0
5450835 2490137 2490137 defendant Worthyngton Robert yeoman 610400 610400 Worthyngton, Robert, of Milford, yeoman 0
5552797 2520868 2520868 defendant Foxholes John, senior husbandman 610400 610400 Foxholes, John, senior, of Milford, husbandman 0
5552798 2520868 2520868 defendant Foxholes John, junior husbandman 610400 610400 Foxholes, John, junior, of Milford, husbandman 1
5556218 2521814 2521814 defendant Clerk William laborer 610400 610400 Clerk, William, of Milford, laborer 5
5575782 2527512 2527512 defendant Collyns William yeoman 610400 610400 Collyns, William, of Milford, yeoman 0
5580365 2528941 2528941 defendant Therle John husbandman 610400 610400 Therle, John, of Milford, husbandman 0
5580367 2528942 2528942 defendant Therle John husbandman 610400 610400 Therle, John, of Milford, husbandman 0
5598692 2534465 2534465 defendant Hall Mathew gent 610400 610400 Hall, Mathew, of Milford, gent 0
5609112 2537757 2537757 defendant Broun John husbandman 610400 610400 Broun, John, of Milford, husbandman 0
5616920 2549101 2549101 defendant Bairgrave John de   610400 610400 Bairgrave, John de, of Milford 1
5630509 2553553 2553553 defendant Mewes John husbandman 610400 610400 Mewes, John, of Milford, husbandman 8
5630510 2553553 2553553 defendant Ben John husbandman 610400 610400 Ben, John, of Milford, husbandman 9

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