names

58 rows where place_id = 603213

✎ 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
3653865 1911472 1911472 defendant Cole Richard husbandman 603213 603213 Cole, Richard, of Framyngham, husbandman 2
3659497 1913228 1913228 defendant Hanham William yeoman 603213 603213 Hanham, William, of Framyngham, yeoman 1
3663958 1914669 1914669 defendant Hill Thomas mercer 603213 603213 Hill, Thomas, of Framyngham, mercer 2
3663962 1914670 1914670 defendant Hill Thomas mercer 603213 603213 Hill, Thomas, of Framyngham, mercer 2
3676374 1918656 1918656 defendant Says John butcher 603213 603213 Says, John, of Framyngham, butcher 0
3727320 1934820 1934820 defendant Gylbert Alexander carpenter 603213 603213 Gylbert, Alexander, of Framyngham, carpenter 1
3762859 1946021 1946021 defendant Wale Andrew husbandman 603213 603213 Wale, Andrew, of Framyngham, husbandman 0
3769180 1948018 1948018 defendant Wale Andrew husbandman 603213 603213 Wale, Andrew, of Framyngham, husbandman 1
3855189 1975256 1975256 defendant Nuttell William husbandman 603213 603213 Nuttell, William, of Framyngham, husbandman 1
3869808 1980146 1980146 defendant Cryspe Edward laborer 603213 603213 Cryspe, Edward, of Framyngham, laborer 1
3900584 1990426 1990426 defendant Erlond William beer brewer 603213 603213 Erlond, William, of Framyngham, beer brewer 1
3957783 2009780 2009780 defendant Hayle William husbandman 603213 603213 Hayle, William, of Framyngham, husbandman 1
4048873 2042039 2042039 defendant Cryckmaye Robert husbandman 603213 603213 Cryckmaye, Robert, of Framyngham, husbandman 2
4079018 2052794 2052794 defendant Buntyng Robert gent 603213 603213 Buntyng, Robert, of Framyngham, gent 1
4079838 2053089 2053089 defendant Buntyng Robert gent 603213 603213 Buntyng, Robert, of Framyngham, gent 1
4110140 2063889 2063889 defendant Ponyett John yeoman 603213 603213 Ponyett, John, of Framyngham, yeoman 1
4112063 2064569 2064569 defendant Cale John grocer 603213 603213 Cale, John, of Framyngham, grocer 0
4112517 2064732 2064732 defendant Grey John husbandman 603213 603213 Grey, John, of Framyngham, husbandman 3
4150192 2078201 2078201 defendant Albon Robert husbandman 603213 603213 Albon, Robert, of Framyngham, husbandman 1
4395822 2163183 2163183 defendant Mapes Robert yeoman 603213 603213 Mapes, Robert, of Framyngham, yeoman 3
4726794 2273651 2273651 defendant Ramsole Emma   603213 603213 Ramsole, Emma, of Framyngham, servant 0
4741358 2277970 2277970 plaintiff Bokenham John   603213 603213 Bokenham, John, of Framyngham 0
4835708 2307164 2307164 defendant Block William chapman 603213 603213 Block, William, of Framyngham, chapman 2
4873551 2318675 2318675 defendant Thornham William   603213 603213 Thornham, William, of Framyngham, gent, marshal of the hall 0
4900006 2326640 2326640 defendant Boneyr John   603213 603213 Boneyr, John, of Framyngham, holy water clerk 1
4927922 2335168 2335168 defendant Langsweyn John dyer 603213 603213 Langsweyn, John, of Framyngham, dyer 1
4927923 2335168 2335168 defendant Irlond William dyer 603213 603213 Irlond, William, of Framyngham, dyer 2
4989577 2353815 2353815 defendant Sutton John husbandman 603213 603213 Sutton, John, of Framyngham, husbandman 5
4989596 2353817 2353817 defendant Setorle Roger yeoman 603213 603213 Setorle, Roger, of Framyngham, yeoman 1
5034775 2367028 2367028 defendant Bacheler John husbandman 603213 603213 Bacheler, John, of Framyngham, husbandman 0
5040289 2368692 2368692 defendant Toure John yeoman 603213 603213 Toure, John, of Framyngham, yeoman 3
5082142 2381151 2381151 defendant Martyn Robert esq 603213 603213 Martyn, Robert, of Framyngham, esq 0
5083507 2381568 2381568 defendant Game or Gaine John chapman 603213 603213 Game or Gaine, John, of Framyngham, chapman 0
5107108 2388508 2388508 defendant Martyn Robert esq 603213 603213 Martyn, Robert, of Framyngham, esq 0
5130440 2395392 2395392 defendant Wale John laborer 603213 603213 Wale, John, of Framyngham, laborer 4
5273507 2437325 2437325 defendant Capon John chapman 603213 603213 Capon, John, of Framyngham, chapman 0
5291323 2442464 2442464 defendant Mason William husbandman 603213 603213 Mason, William, of Framyngham, husbandman 3
5308463 2447568 2447568 defendant Brandon Robert gent 603213 603213 Brandon, Robert, of Framyngham, gent 0
5326707 2453056 2453056 defendant Neweman Robert yeoman 603213 603213 Neweman, Robert, of Framyngham, yeoman 2
5354995 2461632 2461632 plaintiff Hotte Thomas yeoman 603213 603213 Hotte, Thomas, of Framyngham, yeoman 0
5383296 2470298 2470298 defendant Shoice John   603213 603213 Shoice, John, of Framyngham 1
5402733 2475857 2475857 defendant Shorte John   603213 603213 Shorte, John, of Framyngham, tallow chandler 2
5415660 2479626 2479626 defendant Shorte John   603213 603213 Shorte, John, of Framyngham, tallow chandler 2
5427675 2483234 2483234 defendant Wright Reginald yeoman 603213 603213 Wright, Reginald, of Framyngham, yeoman 0
5427676 2483234 2483234 defendant Godard John yeoman 603213 603213 Godard, John, of Framyngham, yeoman 1
5432071 2484558 2484558 defendant Shorte John   603213 603213 Shorte, John, of Framyngham, tallow chandler 2
5434632 2485295 2485295 defendant Debbeney William yeoman 603213 603213 Debbeney, William, of Framyngham, yeoman 0
5444932 2488368 2488368 defendant Debney William husbandman 603213 603213 Debney, William, of Framyngham, husbandman 0
5445355 2488509 2488509 defendant Wright Reginald yeoman 603213 603213 Wright, Reginald, of Framyngham, yeoman 0
5445356 2488509 2488509 defendant Godard John yeoman 603213 603213 Godard, John, of Framyngham, yeoman 1
5458086 2492326 2492326 defendant Godard John yeoman 603213 603213 Godard, John, of Framyngham, yeoman 0
5458098 2492329 2492329 defendant Wright Reginald yeoman 603213 603213 Wright, Reginald, of Framyngham, yeoman 0
5458099 2492329 2492329 defendant Godard John yeoman 603213 603213 Godard, John, of Framyngham, yeoman 1
5458101 2492330 2492330 defendant Wright Reginald yeoman 603213 603213 Wright, Reginald, of Framyngham, yeoman 0
5458102 2492330 2492330 defendant Godard John yeoman 603213 603213 Godard, John, of Framyngham, yeoman 1
5594534 2533270 2533270 defendant Barker John husbandman 603213 603213 Barker, John, of Framyngham, husbandman 0
5631343 2553805 2553805 defendant Canewald Walter butcher 603213 603213 Canewald, Walter, of Framyngham, butcher 0
5631349 2553806 2553806 defendant Canwald Walter butcher 603213 603213 Canwald, Walter, of Framyngham, butcher 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);