names

135 rows where place_id = 590317

✎ 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
3600607 1867837 1867837 defendant Snellyng Henry chapman 590317 590317 Snellyng, Henry, of Dorchester, Dorset, chapman 1
3602391 1868408 1868408 defendant Shete John gent 590317 590317 Shete, John, of Dorchester, Dorset, gent 2
3614493 1872180 1872180 defendant Stone William innholder 590317 590317 Stone, William, of Dorchester, Dorset, innholder 1
3616965 1872927 1872927 defendant Wright Robert mercer 590317 590317 Wright, Robert, of Dorchester, Dorset, mercer 1
3741783 1939292 1939292 defendant Pychard Robert whitawer 590317 590317 Pychard, Robert, of Dorchester, Dorset, whitawer 6
3786160 1953464 1953464 defendant Jamys John merchant 590317 590317 Jamys, John, of Dorchester, Dorset, merchant 0
3786163 1953465 1953465 defendant Jamys John merchant 590317 590317 Jamys, John, of Dorchester, Dorset, merchant 0
3824442 1965515 1965515 defendant Jolyff William gent 590317 590317 Jolyff, William, of Dorchester, Dorset, gent 0
3873566 1981380 1981380 defendant James John merchant 590317 590317 James, John, of Dorchester, Dorset, merchant 1
3877407 1982689 1982689 defendant Holman John butcher 590317 590317 Holman, John, of Dorchester, Dorset, butcher 1
3897535 1989390 1989390 defendant Eston John hardwareman 590317 590317 Eston, John, of Dorchester, Dorset, hardwareman 2
3919037 1996692 1996692 defendant Sampson William yeoman 590317 590317 Sampson, William, of Dorchester, Dorset, yeoman 0
3965868 2012680 2012680 plaintiff Beryett Robert merchant 590317 590317 Beryett, Robert, of Dorchester, Dorset, merchant 0
3989882 2021133 2021133 defendant Smythe George gent 590317 590317 Smythe, George, of Dorchester, Dorset, gent 0
3994413 2022756 2022756 defendant Pynge William merchant 590317 590317 Pynge, William, of Dorchester, Dorset, merchant 0
3996611 2023547 2023547 defendant Scot John mercer 590317 590317 Scot, John, of Dorchester, Dorset, mercer 2
3997291 2023803 2023803 defendant Corbyn Richard baker 590317 590317 Corbyn, Richard, of Dorchester, Dorset, baker 0
3998504 2024203 2024203 defendant Strongman John gent 590317 590317 Strongman, John, of Dorchester, Dorset, gent 0
3999398 2024546 2024546 defendant Stongman or Strongman John gent 590317 590317 Stongman or Strongman, John, of Dorchester, Dorset, gent 0
4002213 2025575 2025575 defendant Terney Christopher chapman 590317 590317 Terney, Christopher, of Dorchester, Dorset, chapman 2
4003460 2026001 2026001 defendant Hayne Morgan chapman 590317 590317 Hayne, Morgan, of Dorchester, Dorset, chapman 0
4012034 2029033 2029033 defendant Hayne Morgan chapman 590317 590317 Hayne, Morgan, of Dorchester, Dorset, chapman 2
4012955 2029364 2029364 defendant Aden William yeoman 590317 590317 Aden, William, of Dorchester, Dorset, yeoman 0
4013969 2029731 2029731 defendant Hemyng John chapman 590317 590317 Hemyng, John, of Dorchester, Dorset, ,chapman 0
4018715 2031426 2031426 defendant Cornelis Mathew (legal representative) 590317 590317 Cornelis, Mathew, of Dorchester, Dorset, merchant, executrix of 0
4023570 2033138 2033138 defendant Hayne Thomas merchant 590317 590317 Hayne, Thomas, of Dorchester, Dorset, merchant 0
4032571 2036299 2036299 plaintiff Gaye Reginald weaver 590317 590317 Gaye, Reginald, of Dorchester, Dorset, weaver 0
4032573 2036300 2036300 plaintiff Gaye Reginald weaver 590317 590317 Gaye, Reginald, of Dorchester, Dorset, weaver 0
4042339 2039743 2039743 defendant Scott John chapman 590317 590317 Scott, John, of Dorchester, Dorset, chapman 0
4042341 2039744 2039744 defendant Skott John chapman 590317 590317 Skott, John, of Dorchester, Dorset, chapman 0
4043681 2040196 2040196 defendant Hennynge John chapman 590317 590317 Hennynge, John, of Dorchester, Dorset, chapman 0
4043685 2040197 2040197 defendant Hennynge John chapman 590317 590317 Hennynge, John, of Dorchester, Dorset, chapman 0
4044004 2040307 2040307 defendant Cellar John merchant 590317 590317 Cellar, John, of Dorchester, Dorset, merchant 0
4044006 2040308 2040308 defendant Cellar John merchant 590317 590317 Cellar, John, of Dorchester, Dorset, merchant 0
4049378 2042222 2042222 defendant Vowell John merchant 590317 590317 Vowell, John, of Dorchester, Dorset, merchant 3
4049383 2042223 2042223 defendant Vowell or Voules John merchant 590317 590317 Vowell or Voules, John, of Dorchester, Dorset, merchant 3
4050310 2042542 2042542 defendant Hennynge John chapman 590317 590317 Hennynge, John, of Dorchester, Dorset, chapman 0
4058255 2045337 2045337 defendant Hayne Morgan yeoman 590317 590317 Hayne, Morgan, of Dorchester, Dorset, yeoman 0
4058257 2045338 2045338 defendant Hayne Thomas mercer 590317 590317 Hayne, Thomas, of Dorchester, Dorset, mercer 0
4062532 2046891 2046891 defendant Mathewe Charles gent 590317 590317 Mathewe, Charles, of Dorchester, Dorset, gent 0
4064714 2047669 2047669 defendant Brent Stephen gent 590317 590317 Brent, Stephen, of Dorchester, Dorset, gent 0
4068800 2049132 2049132 defendant James John   590317 590317 James, John, of Dorchester, Dorset, woollen draper 0
4070505 2049743 2049743 defendant Sherwood Richard   590317 590317 Sherwood, Richard, of Dorchester, Dorset, notary public 0
4095256 2058626 2058626 defendant Stote Walter merchant 590317 590317 Stote, Walter, of Dorchester, Dorset, merchant 0
4101852 2060973 2060973 defendant Adyn Thomas merchant or woollen draper 590317 590317 Adyn, Thomas, of Dorchester, Dorset, merchant or woollen draper 0
4104489 2061888 2061888 defendant Adyn alias Barbett Robert merchant 590317 590317 Adyn alias Barbett, Robert, of Dorchester, Dorset, merchant 0
4111217 2064261 2064261 defendant Colchester Mathew saddler 590317 590317 Colchester, Mathew, of Dorchester, Dorset, saddler 0
4120534 2067621 2067621 defendant Giles John mercer 590317 590317 Giles, John, of Dorchester, Dorset, mercer 0
4123767 2068798 2068798 defendant Keyse John chapman 590317 590317 Keyse, John, of Dorchester, Dorset, chapman 2
4126594 2069796 2069796 defendant Howarde Giles Mary esq 590317 590317 Howarde, Giles Mary, of Dorchester, Dorset, esq 0
4136434 2073372 2073372 defendant Madett John pewterer 590317 590317 Madett, John, of Dorchester, Dorset, pewterer 0
4140353 2074793 2074793 defendant Palmer William brewer 590317 590317 Palmer, William, of Dorchester, Dorset, brewer 0
4142257 2075468 2075468 defendant Speringe Thomas chapman 590317 590317 Speringe, Thomas, of Dorchester, Dorset, chapman 0
4157977 2080860 2080860 defendant Skott John merchant 590317 590317 Skott, John, of Dorchester, Dorset, merchant 1
4158657 2081101 2081101 defendant Bowden Luke gent 590317 590317 Bowden, Luke, of Dorchester, Dorset, gent 2
4160532 2081758 2081758 plaintiff Robinson George gent 590317 590317 Robinson, George, of Dorchester, Dorset, gent 0
4162406 2082409 2082409 defendant Collard Robert chapman 590317 590317 Collard, Robert, of Dorchester, Dorset, chapman 3
4162815 2082542 2082542 defendant Bowdem Luke gent 590317 590317 Bowdem, Luke, of Dorchester, Dorset, gent 1
4162871 2082542 2082542 defendant Elrington Robert   590317 590317 Elrington, Robert, of Dorchester, Dorset, gent, et al 57
4177725 2087682 2087682 defendant Harbyne Henry gent 590317 590317 Harbyne, Henry, of Dorchester, Dorset, gent 0
4180959 2088817 2088817 defendant Smythe George gent 590317 590317 Smythe, George, of Dorchester, Dorset, gent 1
4181413 2088976 2088976 defendant Smythe George gent 590317 590317 Smythe, George, of Dorchester, Dorset, gent 1
4191322 2092528 2092528 defendant Markfeyld William haberdasher 590317 590317 Markfeyld, William, of Dorchester, Dorset, haberdasher 3
4193511 2093296 2093296 defendant Scott John merchant 590317 590317 Scott, John, of Dorchester, Dorset, merchant 0
4194009 2093463 2093463 defendant Graye Walter gent 590317 590317 Graye, Walter, of Dorchester, Dorset, gent 0
4199858 2095500 2095500 defendant Wolrudge John gent 590317 590317 Wolrudge, John, of Dorchester, Dorset, gent 1
4200496 2095733 2095733 defendant Skott Walter merchant 590317 590317 Skott, Walter, of Dorchester, Dorset, merchant 0
4210229 2099136 2099136 defendant Edward Thomas yeoman 590317 590317 Edward, Thomas, of Dorchester, Dorset, yeoman 0
4223766 2103798 2103798 defendant Adams John yeoman 590317 590317 Adams, John, of Dorchester, Dorset, yeoman 0
4223769 2103799 2103799 defendant Adams John yeoman 590317 590317 Adams, John, of Dorchester, Dorset, yeoman 0
4230414 2106131 2106131 defendant Banger Francis butcher 590317 590317 Banger, Francis, of Dorchester, Dorset, butcher 0
4243877 2110933 2110933 defendant Foxwell Thomas mercer 590317 590317 Foxwell, Thomas, of Dorchester, Dorset, mercer 0
4267242 2118683 2118683 defendant Foxwell Thomas mercer 590317 590317 Foxwell, Thomas, of Dorchester, Dorset, mercer 0
4280855 2123207 2123207 defendant Reade Stephen haberdasher 590317 590317 Reade, Stephen, of Dorchester, Dorset, haberdasher 2
4282918 2123926 2123926 defendant Harrys Salomon chapman 590317 590317 Harrys, Salomon, of Dorchester, Dorset, chapman 0
4306192 2132303 2132303 defendant Aden alias Barbutt William   590317 590317 Aden alias Barbutt, William, of Dorchester, Dorset, woollen draper 0
4341629 2144349 2144349 defendant Adyn Methusala draper 590317 590317 Adyn, Methusala, of Dorchester, Dorset, draper 0
4341632 2144350 2144350 defendant Adyn John draper 590317 590317 Adyn, John, of Dorchester, Dorset, draper 0
4357880 2149998 2149998 defendant Standishe Richard tailor 590317 590317 Standishe, Richard, of Dorchester, Dorset, tailor 0
4367779 2153529 2153529 defendant Anketill alias Angthiell George gent 590317 590317 Anketill alias Angthiell, George, of Dorchester, Dorset, or of Wamstedd, Hants, gent 0
4378714 2157459 2157459 defendant Skotte John merchant 590317 590317 Skotte, John, of Dorchester, Dorset, merchant 1
4380953 2158302 2158302 defendant Palmer John innholder 590317 590317 Palmer, John, of Dorchester, Dorset, innholder 2
4391937 2161929 2161929 defendant Palmer John yeoman 590317 590317 Palmer, John, of Dorchester, Dorset, yeoman 1
4400711 2164826 2164826 defendant Davies Nicholas mercer 590317 590317 Davies, Nicholas, of Dorchester, Dorset, mercer 0
4401159 2164983 2164983 defendant David Nicholas mercer 590317 590317 David, Nicholas, of Dorchester, Dorset, mercer 0
4406055 2166593 2166593 defendant Edwardes Henry innholder 590317 590317 Edwardes, Henry, of Dorchester, Dorset, innholder 0
4407626 2167117 2167117 defendant Davie Nicholas chapman 590317 590317 Davie, Nicholas, of Dorchester, Dorset, chapman 0
4410530 2168113 2168113 defendant Newman Agnes spinster 590317 590317 Newman, Agnes, of Dorchester, Dorset, spinster 0
4481641 2194953 2194953 defendant Cravell Henry   590317 590317 Cravell, Henry, of Dorchester, Dorset 0
4504915 2202077 2202077 defendant Gold John   590317 590317 Gold, John, of Dorchester, Dorset 0
4643805 2244284 2244284 defendant Stote John merchant 590317 590317 Stote, John, of Dorchester, Dorset, merchant 0
4658973 2248677 2248677 defendant Martyn William esq 590317 590317 Martyn, William, of Dorchester, Dorset, esq 1
4696747 2264461 2264461 defendant Pury John merchant 590317 590317 Pury, John, of Dorchester, Dorset, merchant 0
4719509 2271444 2271444 defendant Walsshe John merchant 590317 590317 Walsshe, John, of Dorchester, Dorset, merchant 1
4784486 2291152 2291152 defendant Stoury alias Asshe Robert chapman 590317 590317 Stoury alias Asshe, Robert, of Dorchester, Dorset, chapman 0
4797297 2295329 2295329 defendant Cartere Henry dyer 590317 590317 Cartere, Henry, of Dorchester, Dorset, dyer 0
4838142 2307852 2307852 defendant Badde Thomas tailor 590317 590317 Badde, Thomas, of Dorchester, Dorset, tailor 3
4845526 2310112 2310112 defendant Nicholas John weaver 590317 590317 Nicholas, John, of Dorchester, Dorset, weaver 4
4852558 2312222 2312222 defendant Shepton Thomas dyer 590317 590317 Shepton, Thomas, of Dorchester, Dorset, dyer 0
4884860 2322163 2322163 defendant Sadeler Thomas saddler 590317 590317 Sadeler, Thomas, of Dorchester, Dorset, saddler 0

Next page

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