names

40 rows where place_id = 602708

✎ 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
3651366 1910793 1910793 defendant Batell William, senior dyer 602708 602708 Batell, William, senior, of Farneham, Surrey, dyer 1
3754100 1943228 1943228 defendant Manery Thomas smith 602708 602708 Manery, Thomas, of Farneham, Surrey, smith 3
3841627 1970965 1970965 defendant Manery Thomas innholder 602708 602708 Manery, Thomas, of Farneham, Surrey, innholder 0
3958182 2009934 2009934 defendant Brewer Edward yeoman 602708 602708 Brewer, Edward, of Farneham, Surrey, yeoman 1
4022668 2032832 2032832 plaintiff Aston or Assheton Robert gent 602708 602708 Aston or Assheton, Robert, of Farneham, Surrey, gent 0
4057333 2045005 2045005 defendant Aston Robert esq 602708 602708 Aston, Robert, of Farneham, Surrey, esq 0
4057336 2045006 2045006 defendant Chaper Thomas yeoman 602708 602708 Chaper, Thomas, of Farneham, Surrey, yeoman 0
4097794 2059543 2059543 defendant Wagotte Michael chapman or linen draper 602708 602708 Wagotte, Michael, of Farneham, Surrey, chapman or linen draper 0
4159695 2081459 2081459 defendant Gatt William beer brewer 602708 602708 Gatt, William, of Farneham, Surrey, beer brewer 0
4162631 2082491 2082491 defendant Chaper Thomas clothier 602708 602708 Chaper, Thomas, of Farneham, Surrey, clothier 0
4202958 2096581 2096581 defendant Chaper Thomas clothier 602708 602708 Chaper, Thomas, of Farneham, Surrey, clothier 1
4209922 2099031 2099031 defendant Erle William vintner 602708 602708 Erle, William, of Farneham, Surrey, vintner 0
4210280 2099151 2099151 defendant Cover Robert chapman 602708 602708 Cover, Robert, of Farneham, Surrey, chapman 0
4224381 2104013 2104013 defendant Knyghte Thomas gent 602708 602708 Knyghte, Thomas, of Farneham, Surrey, gent 0
4224385 2104014 2104014 defendant Knyghte Thomas gent 602708 602708 Knyghte, Thomas, of Farneham, Surrey, gent 0
4241379 2110102 2110102 defendant Avenell George mercer 602708 602708 Avenell, George, of Farneham, Surrey, mercer 1
4249633 2112861 2112861 defendant Watt John chapman 602708 602708 Watt, John, of Farneham, Surrey, chapman 0
4264035 2117626 2117626 defendant Watt John chapman 602708 602708 Watt, John, of Farneham, Surrey, chapman 0
4303373 2131305 2131305 defendant Brister John clothier 602708 602708 Brister, John, of Farneham, Surrey, clothier 2
4336832 2142610 2142610 defendant More John   602708 602708 More, John, of Farneham, Surrey, woollen draper 0
4347092 2146240 2146240 defendant Burton Edward gent 602708 602708 Burton, Edward, of Farneham, Surrey, gent 1
4361352 2151222 2151222 defendant Hampden Peter gent 602708 602708 Hampden, Peter, of Farneham, Surrey, gent 0
4364658 2152418 2152418 defendant Moore John draper 602708 602708 Moore, John, of Farneham, Surrey, draper 0
4365299 2152653 2152653 defendant Palmer Robert carrier 602708 602708 Palmer, Robert, of Farneham, Surrey, yeoman, carrier 1
4390921 2161577 2161577 defendant Cowsenys Robert chapman 602708 602708 Cowsenys, Robert, of Farneham, Surrey, chapman 2
4394195 2162660 2162660 defendant Parrett John gent 602708 602708 Parrett, John, of Farneham, Surrey, gent 0
4967653 2347266 2347266 defendant Burgeys Richard chapman 602708 602708 Burgeys, Richard, of Farneham, Surrey, chapman 0
5053391 2372617 2372617 defendant Somer William yeoman or drover 602708 602708 Somer, William, of Farneham, Surrey, yeoman or drover 0
5053504 2372653 2372653 defendant Somer William yeoman or drover 602708 602708 Somer, William, of Farneham, Surrey, yeoman or drover 0
5087395 2382695 2382695 defendant Cassy David weaver 602708 602708 Cassy, David, of Farneham, Surrey, weaver 1
5094609 2384834 2384834 defendant Perys Thomas yeoman 602708 602708 Perys, Thomas, of Farneham, Surrey, yeoman 0
5216761 2420638 2420638 defendant Somyr William, senior butcher 602708 602708 Somyr, William, senior, of Farneham, Surrey, drover, or of Redyng, Berks, butcher 0
5229633 2424286 2424286 defendant White John merchant 602708 602708 White, John, of Farneham, Surrey, merchant 1
5233131 2425277 2425277 defendant Whyte John merchant 602708 602708 Whyte, John, of Farneham, Surrey, merchant 0
5325026 2452566 2452566 defendant Russell John   602708 602708 Russell, John, of Farneham, Surrey, yeoman, dwelling with Stillington, Robert, Bishop of Bath and Wells 0
5325031 2452567 2452567 defendant Russell John   602708 602708 Russell, John, of Farneham, Surrey, yeoman, swelling with Stillington, Robert, Bishop of Bath and Wells 0
5333237 2455011 2455011 defendant Whyte John merchant of the staple 602708 602708 Whyte, John, of Farneham, Surrey, gent, son of Whyte, John, of Farneham, merchant of the staple 3
5363369 2464195 2464195 defendant Person Richard chapman 602708 602708 Person, Richard, of Farneham, Surrey, chapman 0
5498130 2504386 2504386 defendant Symkyns John smith 602708 602708 Symkyns, John, of Farneham, Surrey, smith 0
5500345 2505050 2505050 defendant Russell John yeoman 602708 602708 Russell, John, of Farneham, Surrey, yeoman 3

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