names

28 rows where place_id = 634473

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3819098 1963864 1963864 defendant Bysshopp Richard   634473 634473 Bysshopp, Richard, of Gedyngton 0
3856055 1975519 1975519 defendant Glover George chandler 634473 634473 Glover, George, of Gedyngton, chandler 2
3890699 1987155 1987155 defendant Colfox Roger husbandman 634473 634473 Colfox, Roger, of Gedyngton, husbandman 0
4009434 2028139 2028139 defendant Downhall or Donall Richard gent 634473 634473 Downhall or Donall, Richard, of Gedyngton, gent 0
4009435 2028139 2028139 defendant Downhall or Donall William gent 634473 634473 Downhall or Donall, William, of Gedyngton, gent 1
4529739 2209585 2209585 plaintiff Mulso Thomas   634473 634473 Mulso, Thomas, of Gedyngton 0
4529740 2209585 2209585 defendant Wyndesore William   634473 634473 Wyndesore, William, of Gedyngton 0
4604410 2232549 2232549 defendant Mulso Henry   634473 634473 Mulso, Henry, of Gedyngton 0
4614907 2235670 2235670 defendant Mulson Henry   634473 634473 Mulson, Henry, of Gedyngton 0
4653368 2246990 2246990 defendant Mulsho Henry esq 634473 634473 Mulsho, Henry, of Gedyngton, esq 0
4653370 2246991 2246991 defendant Mulsho Henry esq 634473 634473 Mulsho, Henry, of Gedyngton, esq 0
4832653 2306234 2306234 defendant Comefort John husbandman 634473 634473 Comefort, John, of Gedyngton, husbandman 0
4844413 2309765 2309765 defendant Barker Thomas tanner 634473 634473 Barker, Thomas, of Gedyngton, tanner 0
4871846 2318166 2318166 plaintiff Mulso Thomas esq 634473 634473 Mulso, Thomas, of Gedyngton, esq 0
4882635 2321482 2321482 defendant Fenkyll Henry barker 634473 634473 Fenkyll, Henry, of Gedyngton, barker 1
4988589 2353544 2353544 defendant Freman Lawrence husbandman 634473 634473 Freman, Lawrence, of Gedyngton, husbandman 3
5061150 2374913 2374913 defendant Baker John miller 634473 634473 Baker, John, of Gedyngton, miller 1
5061151 2374913 2374913 defendant Baker William tailor 634473 634473 Baker, William, of Gedyngton, tailor 2
5097273 2385632 2385632 defendant Symond Thomas butcher 634473 634473 Symond, Thomas, of Gedyngton, butcher 0
5218484 2421138 2421138 defendant Mulso Margaret widow 634473 634473 Mulso, Margaret, of Gedyngton, widow 0
5271475 2436750 2436750 defendant Clerk Nicholas butcher 634473 634473 Clerk, Nicholas, of Gedyngton, butcher 2
5273722 2437394 2437394 defendant Bocher Nicholas butcher 634473 634473 Bocher, Nicholas, of Gedyngton, butcher 1
5298149 2444474 2444474 defendant Bette Thomas yeoman 634473 634473 Bette, Thomas, of Gedyngton, yeoman 1
5314373 2449321 2449321 defendant Knyght Thomas husbandman 634473 634473 Knyght, Thomas, of Gedyngton, husbandman 0
5375000 2467773 2467773 defendant Byard John husbandman 634473 634473 Byard, John, of Gedyngton, husbandman 2
5382369 2470015 2470015 defendant Bayard John husbandman 634473 634473 Bayard, John, of Gedyngton, husbandman 3
5491351 2502301 2502301 defendant Bocher Nicholas butcher 634473 634473 Bocher, Nicholas, of Gedyngton, butcher 0
5517339 2510263 2510263 defendant Vysacurley Nicholas gent 634473 634473 Vysacurley, Nicholas, of Gedyngton, 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);