names

48 rows where place_id = 588894

✎ 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
3595938 1866363 1866363 defendant Stampe Thomas yeoman 588894 588894 Stampe, Thomas, of Shute, yeoman 0
3595939 1866363 1866363 defendant Waryn David   588894 588894 Waryn, David, of Shute, physician 1
3595940 1866363 1866363 defendant Strobrygge William yeoman 588894 588894 Strobrygge, William, of Shute, yeoman 2
3595941 1866363 1866363 defendant Brounston William yeoman 588894 588894 Brounston, William, of Shute, yeoman 3
3595942 1866363 1866363 defendant A Bankes John husbandman 588894 588894 A Bankes, John, of Shute, husbandman 4
3595943 1866363 1866363 defendant atte Benne William husbandman 588894 588894 atte Benne, William, of Shute, husbandman 5
3595945 1866363 1866363 defendant Hore John husbandman 588894 588894 Hore, John, of Shute, husbandman 7
3595946 1866363 1866363 defendant Coton Thomas husbandman 588894 588894 Coton, Thomas, of Shute, husbandman 8
3595947 1866363 1866363 defendant Carter Thomas husbandman 588894 588894 Carter, Thomas, of Shute, husbandman 9
3595950 1866363 1866363 defendant Bonvyle John esq 588894 588894 Bonvyle, John, of Shute, esq 12
3615955 1872626 1872626 defendant Yonge Walter yeoman 588894 588894 Yonge, Walter, of Shute, yeoman 2
3618439 1873398 1873398 defendant Cotyn Thomas smith 588894 588894 Cotyn, Thomas, of Shute, smith 0
3618440 1873398 1873398 defendant Smyth John husbandman 588894 588894 Smyth, John, of Shute, husbandman 1
3618441 1873398 1873398 defendant Catchepolle William husbandman 588894 588894 Catchepolle, William, of Shute, husbandman 2
3618442 1873398 1873398 defendant Starre John husbandman 588894 588894 Starre, John, of Shute, husbandman 3
3618443 1873398 1873398 defendant Hore John husbandman 588894 588894 Hore, John, of Shute, husbandman 4
3618444 1873398 1873398 defendant Smyth John butcher 588894 588894 Smyth, John, of Shute, butcher 5
3618445 1873398 1873398 defendant Abanke John husbandman 588894 588894 Abanke, John, of Shute, husbandman 6
3618446 1873398 1873398 defendant Goolde Henry tanner 588894 588894 Goolde, Henry, of Shute, tanner 7
3618454 1873399 1873399 defendant Yonge Walter yeoman 588894 588894 Yonge, Walter, of Shute, yeoman 3
3699103 1925927 1925927 defendant Power Gilbert husbandman 588894 588894 Power, Gilbert, of Shute, husbandman 1
3721390 1932999 1932999 defendant Thorne Thomas gent 588894 588894 Thorne, Thomas, of Shute, gent 0
3733856 1936839 1936839 defendant Cordrey Thomas yeoman 588894 588894 Cordrey, Thomas, of Shute, yeoman 0
4039631 2038785 2038785 defendant Baseley John yeoman 588894 588894 Baseley, John, of Shute, yeoman 0
4077344 2052180 2052180 plaintiff Sparke John   588894 588894 Sparke, John, of Shute 0
4108139 2063182 2063182 defendant Blackaller Peter gent 588894 588894 Blackaller, Peter, of Shute, gent 2
4308392 2133089 2133089 defendant Keyver or Keaver William   588894 588894 Keyver or Keaver, William, of Shute, sleigh maker 0
4321028 2137448 2137448 defendant Baselie John, senior husbandman 588894 588894 Baselie, John, senior, of Shute, husbandman 0
4340535 2143955 2143955 defendant Baseley John yeoman 588894 588894 Baseley, John, of Shute, yeoman 0
4378445 2157362 2157362 defendant White Toby merchant 588894 588894 White, Toby, of Shute, merchant 0
4381140 2158372 2158372 defendant Newton John husbandman 588894 588894 Newton, John, of Shute, husbandman 0
5055995 2373364 2373364 defendant Gyldon Richard gent 588894 588894 Gyldon, Richard, of Shute, gent 3
5100366 2386547 2386547 defendant Grenefeld Thomas gent 588894 588894 Grenefeld, Thomas, of Shute, gent 0
5112314 2389988 2389988 defendant Whytyng Nicholas yeoman 588894 588894 Whytyng, Nicholas, of Shute, yeoman 0
5126341 2394185 2394185 defendant Whitryng Nicholas gent 588894 588894 Whitryng, Nicholas, of Shute, gent 0
5144984 2399683 2399683 defendant Whityng Nicholas gent 588894 588894 Whityng, Nicholas, of Shute, gent 0
5202114 2416387 2416387 defendant Whityng Nicholas gent 588894 588894 Whityng, Nicholas, of Shute, gent 0
5453006 2490779 2490779 defendant Bonvyle Bastard John gent 588894 588894 Bonvyle Bastard, John, of Shute, gent 0
5453956 2491073 2491073 defendant More John a yeoman 588894 588894 More, John a, of Shute, yeoman 3
5455402 2491530 2491530 defendant Wotton Alexander yeoman 588894 588894 Wotton, Alexander, of Shute, yeoman 0
5455404 2491530 2491530 defendant More John yeoman 588894 588894 More, John, of Shute, yeoman 2
5457360 2492102 2492102 defendant Bonvyle Bastard John gent 588894 588894 Bonvyle Bastard, John, of Shute, gent 1
5464973 2494434 2494434 defendant Bonvyle Bastard John gent 588894 588894 Bonvyle Bastard, John, of Shute, gent 0
5465872 2494709 2494709 defendant a More John yeoman 588894 588894 a More, John, of Shute, yeoman 3
5469180 2495712 2495712 defendant Bonvyle Bastard John gent 588894 588894 Bonvyle Bastard, John, of Shute, gent 0
5476479 2497969 2497969 defendant Bonvyle Bastard John gent 588894 588894 Bonvyle Bastard, John, of Shute, gent 0
5477345 2498233 2498233 defendant a More John yeoman 588894 588894 a More, John, of Shute, yeoman 3
5488947 2501566 2501566 defendant A More John yeoman 588894 588894 A More, John, of Shute, yeoman 2

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