names

38 rows where place_id = 602243

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595885 1866348 1866348 defendant Bradley William yeoman 602243 602243 Bradley, William, of Topclyff, butcher: Stokdale, Henry, of Topclyf, yeoman 2
3649133 1910116 1910116 defendant Horseley Thomas yeoman 602243 602243 Horseley, Thomas, of Topclyff, yeoman 0
3649134 1910116 1910116 defendant Horseley William yeoman 602243 602243 Horseley, William, of Topclyff, yeoman 1
3841146 1970808 1970808 defendant Hexham Richard yeoman 602243 602243 Hexham, Richard, of Topclyff, yeoman 2
3948435 2006516 2006516 defendant Bell William yeoman 602243 602243 Bell, William, of Topclyff, yeoman 0
3956547 2009356 2009356 plaintiff Norton John esq 602243 602243 Norton, John, of Topclyff, esq 0
4072919 2050612 2050612 plaintiff Pecke Nicholas gent 602243 602243 Pecke, Nicholas, of Topclyff, gent 0
4388840 2160899 2160899 defendant Stables or Stulles Richard butcher 602243 602243 Stables or Stulles, Richard, of Topclyff, butcher 0
4500234 2200698 2200698 defendant Symson John   602243 602243 Symson, John, of Topclyff 5
4654161 2247184 2247184 defendant Conway John dyer 602243 602243 Conway, John, of Topclyff, dyer 0
4669026 2256018 2256018 defendant Watkynson William husbandman 602243 602243 Watkynson, William, of Topclyff, husbandman 2
4681514 2259831 2259831 defendant Flesshewer Henry butcher 602243 602243 Flesshewer, Henry, of Topclyff, butcher 0
4775085 2288200 2288200 defendant Williamson John yeoman 602243 602243 Williamson, John, of Topclyff, yeoman 0
4895942 2325398 2325398 defendant Chatton William fisher 602243 602243 Chatton, William, of Topclyff, fisher 1
5134493 2396582 2396582 defendant Tyrwhyte Robert yeoman 602243 602243 Tyrwhyte, Robert, of Topclyff, yeoman 0
5134494 2396582 2396582 defendant Halle William yeoman 602243 602243 Halle, William, of Topclyff, yeoman 1
5154385 2402438 2402438 defendant Tyrwhite Thomas yeoman 602243 602243 Tyrwhite, Thomas, of Topclyff, yeoman 0
5154386 2402438 2402438 defendant Halle William yeoman 602243 602243 Halle, William, of Topclyff, yeoman 1
5171481 2407380 2407380 defendant Tyrwhyte Thomas yeoman 602243 602243 Tyrwhyte, Thomas, of Topclyff, yeoman 0
5171482 2407380 2407380 defendant Halle William yeoman 602243 602243 Halle, William, of Topclyff, yeoman 1
5189959 2412802 2412802 defendant Tirwhite Thomas yeoman 602243 602243 Tirwhite, Thomas, of Topclyff, yeoman 0
5189960 2412802 2412802 defendant Halle William yeoman 602243 602243 Halle, William, of Topclyff, yeoman 1
5213822 2419771 2419771 defendant Lytster Willim dyer 602243 602243 Lytster, Willim, of Topclyff, dyer 1
5215953 2420394 2420394 defendant Smyth Thomas yeoman 602243 602243 Smyth, Thomas, of Topclyff, yeoman 0
5273771 2437410 2437410 defendant Thurwhyte John   602243 602243 Thurwhyte, John, of Topclyff 2
5287629 2441410 2441410 defendant Stokdale Oliver yeoman 602243 602243 Stokdale, Oliver, of Topclyff, yeoman 0
5287630 2441410 2441410 defendant Bullok John yeoman 602243 602243 Bullok, John, of Topclyff, yeoman 1
5287631 2441410 2441410 defendant Hobson William yeoman 602243 602243 Hobson, William, of Topclyff, yeoman 2
5287632 2441410 2441410 defendant Terquett John yeoman 602243 602243 Terquett, John, of Topclyff, yeoman 3
5318597 2450656 2450656 defendant Wath George husbandman 602243 602243 Wath, George, of Topclyff, husbandman 0
5318598 2450656 2450656 defendant Wath Thomas husbandman 602243 602243 Wath, Thomas, of Topclyff, husbandman 1
5318601 2450657 2450657 defendant Wath George husbandman 602243 602243 Wath, George, of Topclyff, husbandman 0
5318602 2450657 2450657 defendant Wath Thomas husbandman 602243 602243 Wath, Thomas, of Topclyff, husbandman 1
5335761 2455761 2455761 defendant Wath Richard husbandman 602243 602243 Wath, Richard, of Topclyff, husbandman 0
5375195 2467829 2467829 defendant Tirwhyt John   602243 602243 Tirwhyt, John, of Topclyff 0
5386706 2471263 2471263 defendant Milner Richard miller 602243 602243 Milner, Richard, of Topclyff, miller 0
5412100 2478573 2478573 defendant (illegible) William yeoman 602243 602243 _, William, of Topclyff, yeoman 0
5477426 2498264 2498264 defendant Herlesay William yeoman 602243 602243 Herlesay, William, of Topclyff, 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);