names

63 rows where place_id = 609793

✎ 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
3680349 1919932 1919932 plaintiff Richard John mercer 609793 609793 Richard, John, of Bungaye, mercer 0
3680350 1919932 1919932 defendant Saunderson Peter mercer 609793 609793 Saunderson, Peter, of Bungaye, mercer 0
3945382 2005470 2005470 defendant Woddall Hamon chapman 609793 609793 Woddall, Hamon, of Bungaye, chapman 0
3957729 2009763 2009763 plaintiff Pryckett Robert   609793 609793 Pryckett, Robert, of Bungaye 0
3957730 2009763 2009763 defendant Button Nicholas   609793 609793 Button, Nicholas, of Bungaye, tanner, administrators of 0
3967092 2013116 2013116 defendant Bellward William sherman 609793 609793 Bellward, William, of Bungaye, sherman 0
3967093 2013116 2013116 defendant Myllers John tailor 609793 609793 Myllers, John, of Bungaye, tailor 1
3969278 2013861 2013861 defendant Abbes or Abbys William husbandman 609793 609793 Abbes or Abbys, William, of Bungaye, husbandman 0
3969453 2013923 2013923 defendant Wharton Richard tanner 609793 609793 Wharton, Richard, of Bungaye, tanner 0
3991942 2021878 2021878 plaintiff Brownyng Gregory bowyer 609793 609793 Brownyng, Gregory, of Bungaye, bowyer 0
4017823 2031088 2031088 plaintiff Townesend Eleanor widow 609793 609793 Townesend, Eleanor, of Bungaye, widow 0
4017849 2031095 2031095 plaintiff Townsend Eleanor widow 609793 609793 Townsend, Eleanor, of Bungaye, widow 0
4030527 2035576 2035576 plaintiff Edward Robert, senior (legal representative) 609793 609793 Edward, Robert, senior, of Bungaye, shoemaker, administratrix of 0
4030529 2035576 2035576 defendant Freman Thomas yeoman 609793 609793 Freman, Thomas, of Bungaye, yeoman 0
4030530 2035576 2035576 defendant Leke John chandler 609793 609793 Leke, John, of Bungaye, clerk, or of Beccles, chandler 1
4031671 2035993 2035993 plaintiff Foster Robert tailer 609793 609793 Foster, Robert, of Bungaye, tailer 0
4031673 2035994 2035994 plaintiff Foster Robert tailor 609793 609793 Foster, Robert, of Bungaye, tailor 0
4045278 2040770 2040770 plaintiff Russhmer Thomas yeoman 609793 609793 Russhmer, Thomas, of Bungaye, yeoman 0
4046037 2041023 2041023 defendant Button Alice widow 609793 609793 Button, Alice, of Bungaye, widow 1
4051639 2043006 2043006 defendant Goodale Robert butcher 609793 609793 Goodale, Robert, of Bungaye, butcher 0
4055216 2044260 2044260 plaintiff Shepparde Elizabeth   609793 609793 Elizabeth his wife, alias Elizabeth Belson, of Bungaye 2
4060758 2046254 2046254 plaintiff Denny Edmund shoemaker 609793 609793 Denny, Edmund, of Bungaye, shoemaker 0
4060759 2046254 2046254 defendant Hyndes Miles glover 609793 609793 Hyndes, Miles, of Bungaye, glover 0
4061737 2046599 2046599 defendant Rose Henry tailor 609793 609793 Rose, Henry, of Bungaye, tailor 0
4061738 2046599 2046599 defendant Whetley William yeoman 609793 609793 Whetley, William, of Bungaye, yeoman 1
4061739 2046599 2046599 defendant Mannynge John yeoman 609793 609793 Mannynge, John, of Bungaye, yeoman 2
4067745 2048775 2048775 plaintiff Johnson Francis yeoman 609793 609793 Johnson, Francis, of Bungaye, or of Wingefeld, yeoman 0
4067749 2048776 2048776 plaintiff Johnson Francis singleman 609793 609793 Johnson, Francis, of Bungaye, yeoman, or of Wingefeld, singleman 0
4077437 2052219 2052219 defendant Browne William merchant 609793 609793 Browne, William, of Bungaye, merchant 0
4086613 2055500 2055500 defendant Goodale Robert butcher 609793 609793 Goodale, Robert, of Bungaye, butcher 0
4086614 2055500 2055500 defendant Goodale William butcher 609793 609793 Goodale, William, of Bungaye, butcher 1
4115515 2065836 2065836 defendant Thackar Thomas tailor 609793 609793 Thackar, Thomas, of Bungaye, tailor 0
4188582 2091485 2091485 defendant Gooch Michael tanner 609793 609793 Gooch, Michael, of Bungaye, tanner 0
4199454 2095358 2095358 defendant Huggyns William (legal representative) 609793 609793 Huggyns, William, of Bungaye, vintner, administratrix of 0
4208499 2098525 2098525 defendant Haylock Thomas butcher 609793 609793 Haylock, Thomas, of Bungaye, husbandman, butcher 0
4216528 2101274 2101274 defendant Cossey Francis husbandman 609793 609793 Cossey, Francis, of Bungaye, husbandman 0
4216529 2101274 2101274 defendant Godbold Roger husbandman 609793 609793 Godbold, Roger, of Bungaye, husbandman 1
4216530 2101274 2101274 defendant Calley Simon husbandman 609793 609793 Calley, Simon, of Bungaye, husbandman 2
4246422 2111781 2111781 defendant Creake Robert butcher 609793 609793 Creake, Robert, of Bungaye, butcher 0
4250792 2113242 2113242 defendant Creake Robert butcher 609793 609793 Creake, Robert, of Bungaye, butcher 1
4273990 2120845 2120845 defendant Fysher Robert yeoman 609793 609793 Fysher, Robert, of Bungaye, yeoman 3
4274360 2120977 2120977 defendant Prickett Robert yeoman 609793 609793 Prickett, Robert, of Bungaye, yeoman 0
4276106 2121589 2121589 defendant Barbor John shoemaker 609793 609793 Barbor, John, of Bungaye, shoemaker 2
4282293 2123708 2123708 defendant Back Richard innholder 609793 609793 Back, Richard, of Bungaye, innholder 0
4325128 2138787 2138787 defendant Greene William gent 609793 609793 Greene, William, of Bungaye, gent 0
4325129 2138787 2138787 defendant Moore Robert yeoman 609793 609793 Moore, Robert, of Bungaye, yeoman 1
4325951 2139054 2139054 defendant Belwarde John weaver 609793 609793 Belwarde, John, of Bungaye, weaver 0
4325953 2139054 2139054 defendant Browne William carpenter 609793 609793 Browne, William, of Bungaye, carpenter 2
4327286 2139452 2139452 defendant Calner or Calver James saddler 609793 609793 Calner or Calver, James, of Bungaye, saddler 0
4328234 2139757 2139757 defendant Stacye William yeoman 609793 609793 Stacye, William, of Bungaye, yeoman 0
4330742 2140583 2140583 defendant Caverne James saddler 609793 609793 Caverne, James, of Bungaye, saddler 3
4333104 2141359 2141359 defendant Creake Robert butcher 609793 609793 Creake, Robert, of Bungaye, butcher 0
4342249 2144570 2144570 defendant Chylde John   609793 609793 Chylde, John, of Bungaye, mason 0
4356266 2149416 2149416 defendant Owers George (legal representative) 609793 609793 Owers, George, of Bungaye, yeoman, executor of 0
4366316 2152993 2152993 defendant Huggens Thomas laborer 609793 609793 togeyher with Huggens, Thomas, of Bungaye, laborer 2
4386610 2160198 2160198 defendant Reve alias Bullock Robert   609793 609793 Reve alias Bullock, Robert, of Bungaye, spoon maker 2
4393206 2162335 2162335 defendant Brodebanck Ralph sherman 609793 609793 Brodebanck, Ralph, of Bungaye, sherman 1
4393822 2162535 2162535 defendant Warde John   609793 609793 Warde, John, of Bungaye tanner 2
4583654 2226306 2226306 plaintiff Fulburn Robert (legal representative) 609793 609793 Fulburn, Robert, of Bungaye, executors of 0
4583656 2226306 2226306 plaintiff Rabbat John   609793 609793 Rabbat, John, of Bungaye 2
4583659 2226307 2226307 plaintiff Fulburn Robert (legal representative) 609793 609793 Fulburn, Robert, of Bungaye, executors of 0
4583661 2226307 2226307 plaintiff Rabbat John   609793 609793 Rabbat, John, of Bungaye 2
4616592 2236190 2236190 defendant Herde John   609793 609793 (Herde, John, of Bungaye, perpetual vicar 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);