names

36 rows where place_id = 588817

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595695 1866282 1866282 defendant Bailiff Ralph yeoman 588817 588817 Bailiff, Ralph, of Streteham, yeoman 0
3657702 1912659 1912659 defendant Bolton John laborer 588817 588817 Bolton, John, of Streteham, laborer 1
3836524 1969329 1969329 defendant Johnson Ralph gent 588817 588817 Johnson, Ralph, of Streteham, gent 0
3836525 1969329 1969329 defendant Hollond Henry husbandman 588817 588817 Hollond, Henry, of Streteham, husbandman 1
3836529 1969329 1969329 defendant Heryngman John husbandman 588817 588817 Heryngman, John, of Streteham, husbandman 5
3983868 2019002 2019002 defendant Orgle John husbandman 588817 588817 Orgle, John, of Streteham, husbandman 1
4684042 2260617 2260617 defendant Colbronde William tilemaker 588817 588817 Colbronde, William, of Streteham, tilemaker 0
4857033 2313580 2313580 defendant Grene John yeoman 588817 588817 Grene, John, of Streteham, yeoman 0
4881943 2321250 2321250 defendant Everard Thomas husbandman 588817 588817 Everard, Thomas, of Streteham, husbandman 1
4881946 2321251 2321251 defendant Everard Thomas husbandman 588817 588817 Everard, Thomas, of Streteham, husbandman 1
4887404 2322899 2322899 defendant Sherle Robert tiler 588817 588817 Sherle, Robert, of Streteham, tiler 0
5068245 2377007 2377007 defendant Michell Robert husbandman 588817 588817 Michell, Robert, of Streteham, husbandman 0
5068246 2377007 2377007 defendant Munsy William husbandman 588817 588817 Munsy, William, of Streteham, husbandman 1
5082800 2381362 2381362 defendant Snell or Suell Thomas husbandman 588817 588817 Snell or Suell, Thomas, of Streteham, husbandman 0
5113959 2390472 2390472 defendant Snell or Suell Thomas yeoman 588817 588817 Snell or Suell, Thomas, of Streteham, yeoman 0
5141988 2398777 2398777 defendant Tyler Gerard tiler 588817 588817 Tyler, Gerard, of Streteham, tiler 0
5163107 2404938 2404938 defendant Tyler Gerard tiler 588817 588817 Tyler, Gerard, of Streteham, tiler 0
5176906 2408936 2408936 defendant Tyler Gerard tiler 588817 588817 Tyler, Gerard, of Streteham, tiler 0
5219603 2421468 2421468 defendant Gerard John husbandman 588817 588817 Gerard, John, of Streteham, husbandman 3
5272515 2437035 2437035 defendant Wright John laborer 588817 588817 Wright, John, of Streteham, laborer 0
5308543 2447592 2447592 defendant Blanchard Thomas husbandman 588817 588817 Blanchard, Thomas, of Streteham, husbandman 0
5308545 2447592 2447592 defendant Croft John husbandman 588817 588817 Croft, John, of Streteham, husbandman 2
5308546 2447592 2447592 defendant Croft Adam husbandman 588817 588817 Croft, Adam, of Streteham, husbandman 3
5308547 2447592 2447592 defendant Boton John   588817 588817 Boton, John, of Streteham 4
5308549 2447592 2447592 defendant Sutton Thomas   588817 588817 Sutton, Thomas, of Streteham, tile maker 6
5324179 2452319 2452319 defendant Webster William fisher 588817 588817 Webster, William, of Streteham, fisher 0
5338578 2456636 2456636 defendant Acton John yeoman 588817 588817 Acton, John, of Streteham, yeoman 0
5420889 2481176 2481176 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5439971 2486899 2486899 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5439978 2486900 2486900 defendant Craft John husbandman 588817 588817 together with Craft, John, of Streteham, husbandman 2
5453517 2490945 2490945 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5465415 2494566 2494566 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5465422 2494567 2494567 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5476909 2498098 2498098 defendant Craft John husbandman 588817 588817 Craft, John, of Streteham, husbandman 2
5604990 2536430 2536430 defendant Paryse William fisher 588817 588817 Paryse, William, of Streteham, fisher 2
5605081 2536459 2536459 defendant Chorlton John yeoman 588817 588817 Chorlton, John, of Streteham, yeoman 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);