names

50 rows where place_id = 604465

✎ 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
3658089 1912784 1912784 defendant Squyrry Henry yeoman 604465 604465 Squyrry, Henry, of Croydon, Surr, yeoman 0
3659387 1913196 1913196 defendant Atwode Edward gent 604465 604465 Atwode, Edward, of Croydon, Surr, gent 0
3665822 1915249 1915249 defendant Wylde Henry gent 604465 604465 Wylde, Henry, of Croydon, Surr, gent 2
3665847 1915252 1915252 defendant Wilde Henry gent & London draper 604465 604465 Wilde, Henry, of Croydon, Surr, gent & London draper 2
4673645 2257387 2257387 defendant Spicer John spicer 604465 604465 Spicer, John, of Croydon, Surr, spicer 2
4673651 2257390 2257390 defendant Spicer John speicer 604465 604465 Spicer, John, of Croydon, Surr, speicer 0
4822745 2303193 2303193 defendant Roberd Thomas laborer 604465 604465 Roberd, Thomas, of Croydon, Surr, laborer 1
4907684 2328970 2328970 defendant Horton John tilemaker 604465 604465 Horton, John, of Croydon, Surr, tilemaker 2
4919044 2332469 2332469 defendant Selverman Thomas mercer 604465 604465 Selverman, Thomas, of Croydon, Surr, mercer 0
4926214 2334621 2334621 plaintiff Purpyt William chapman 604465 604465 Purpyt, William, of Croydon, surr, chapman 0
5130533 2395412 2395412 defendant S--- Reginald yeoman 604465 604465 S---, Reginald, of Croydon, Surr, yeoman 2
5133255 2396212 2396212 defendant Longlond William yeoman 604465 604465 Longlond, William, of Croydon, Surr, yeoman 0
5133257 2396213 2396213 defendant Longlond William yeoman 604465 604465 Longlond, William, of Croydon, Surr, yeoman 0
5136235 2397114 2397114 defendant Heriette Elizabeth widow 604465 604465 Heriette, Elizabeth, of Croydon, Surr, widow 2
5270311 2436419 2436419 defendant Shadde Henry carpenter 604465 604465 Shadde, Henry, of Croydon, Surr, carpenter 1
5270585 2436493 2436493 defendant Purpyt William yeoman 604465 604465 Purpyt, William, of Croydon, Surr, yeoman 0
5272318 2436973 2436973 defendant Crofte Nicholas husbandman 604465 604465 Crofte, Nicholas, of Croydon, Surr, husbandman 2
5273155 2437219 2437219 defendant Ostede or Ustede John husbandman 604465 604465 Ostede or Ustede, John, of Croydon, Surr, husbandman 0
5275621 2437937 2437937 defendant Claybroke William yeoman 604465 604465 Claybroke, William, of Croydon, Surr, yeoman 1
5275708 2437960 2437960 defendant Hatcher William husbandman 604465 604465 Hatcher, William, of Croydon, Surr, husbandman 0
5367160 2465376 2465376 defendant Saunder Henry gent 604465 604465 Saunder, Henry, of Croydon, Surr, gent 0
5367162 2465377 2465377 defendant Saunder Henry gent 604465 604465 Saunder, Henry, of Croydon, Surr, gent 0
5372045 2466852 2466852 defendant Pieres James yeoman 604465 604465 Pieres, James, of Croydon, Surr, yeoman 0
5373306 2467249 2467249 defendant Pyers James yeoman 604465 604465 Pyers, James, of Croydon, Surr, yeoman 0
5389532 2472061 2472061 defendant Pyers James yeoman 604465 604465 Pyers, James, of Croydon, Surr, yeoman 0
5389534 2472061 2472061 defendant Whaplode William yeoman 604465 604465 Whaplode, William, of Croydon, Surr, yeoman 2
5390216 2472265 2472265 defendant Berdell William yeoman 604465 604465 Berdell, William, of Croydon, Surr, yeoman 2
5390219 2472265 2472265 defendant Wellys Agnes widow 604465 604465 Wellys, Agnes, of Croydon, Surr, widow 5
5390224 2472266 2472266 defendant Pyers Jacob yeoman 604465 604465 Pyers, Jacob, of Croydon, Surr, yeoman 2
5397273 2474304 2474304 defendant Mylch Mathew smith 604465 604465 Mylch, Mathew, of Croydon, Surr, smith 0
5403009 2475942 2475942 defendant Baydell William yeoman 604465 604465 Baydell, William, of Croydon, Surr, yeoman 2
5410434 2478068 2478068 defendant Blanford John husbandman 604465 604465 Blanford, John, of Croydon, Surr, husbandman 0
5410486 2478082 2478082 defendant Mylch Mathew smith 604465 604465 Mylch, Mathew, of Croydon, Surr, smith 0
5416010 2479720 2479720 defendant Beydell William yeoman 604465 604465 Beydell, William, of Croydon, Surr, yeoman 0
5416017 2479723 2479723 defendant Wellis Agnes widow 604465 604465 Wellis, Agnes, of Croydon, Surr, widow 1
5424292 2482232 2482232 defendant Beauford Robert husbandman 604465 604465 Beauford, Robert, of Croydon, Surr, husbandman 0
5424296 2482233 2482233 defendant Blanford Robert husbandman 604465 604465 Blanford, Robert, of Croydon, Surr, husbandman 0
5424300 2482234 2482234 defendant Blanford Robert husbandman 604465 604465 Blanford, Robert, of Croydon, Surr, husbandman 0
5424391 2482259 2482259 defendant Mylch Mathew smith 604465 604465 Mylch, Mathew, of Croydon, Surr, smith 0
5435386 2485523 2485523 defendant Davy Ralph carpenter 604465 604465 Davy, Ralph, of Croydon, Surr, carpenter 4
5440577 2487088 2487088 defendant Bukley John husbandman 604465 604465 Bukley, John, of Croydon, Surr, husbandman 0
5450413 2490011 2490011 defendant Davy Ralph carpenter 604465 604465 Davy, Ralph, of Croydon, Surr, carpenter 2
5450421 2490013 2490013 defendant Davy Ralph carpenter 604465 604465 Davy, Ralph, of Croydon, Surr, carpenter 4
5453894 2491055 2491055 defendant Bukley John husbandman 604465 604465 Bukley, John, of Croydon, Surr, husbandman 0
5462525 2493700 2493700 defendant Edward John tailor 604465 604465 Edward, John, of Croydon, Surr, tailor 0
5465767 2494677 2494677 defendant Bukley John husbandman 604465 604465 Bukley, John, of Croydon, Surr, husbandman 0
5472573 2496763 2496763 defendant Piers James yeoman 604465 604465 Piers, James, of Croydon, Surr, yeoman 0
5472576 2496764 2496764 defendant Pyers James yeoman 604465 604465 Pyers, James, of Croydon, Surr, yeoman 0
5474057 2497218 2497218 defendant Edward John tailor 604465 604465 Edward, John, of Croydon, Surr, tailor 0
5474059 2497219 2497219 defendant Edward John tailor 604465 604465 Edward, John, of Croydon, Surr, tailor 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);