names

35 rows where place_id = 589479

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597751 1866916 1866916 defendant Longe Robert husbandman 589479 589479 Longe, Robert, of Chetham, husbandman 1
3615210 1872403 1872403 defendant Badsoll William husbandman 589479 589479 Badsoll, William, of Chetham, husbandman 1
3712292 1930159 1930159 defendant Atwode Richard laborer 589479 589479 Atwode, Richard, of Chetham, laborer 3
3719875 1932486 1932486 defendant Webbe Richard husbandman 589479 589479 Webbe, Richard, of Chetham, husbandman 0
3719876 1932486 1932486 defendant Clerke Robert laborer 589479 589479 Clerke, Robert, of Chetham, laborer 1
3719877 1932486 1932486 defendant Carter Richard laborer 589479 589479 Carter, Richard, of Chetham, laborer 2
3745306 1940438 1940438 defendant Long William husbandman 589479 589479 Long, William, of Chetham, husbandman 0
3786482 1953563 1953563 defendant Long William husbandman 589479 589479 Long, William, of Chetham, husbandman 0
3786485 1953564 1953564 defendant Long William husbandman 589479 589479 Long, William, of Chetham, husbandman 0
3862863 1977771 1977771 defendant Lorkyn John, senior yeoman 589479 589479 Lorkyn, John, senior, of Chetham, yeoman 0
3868665 1979761 1979761 defendant Canon Thomas husbandman 589479 589479 Canon, Thomas, of Chetham, husbandman 0
3963669 2011904 2011904 plaintiff Addisley William (legal representative) 589479 589479 Addisley, William, of Chetham, husbandman, executrix of 0
4176131 2087127 2087127 defendant Barnes William mariner 589479 589479 Barnes, William, of Chetham, mariner 1
4533238 2210655 2210655 defendant Twymere William   589479 589479 Twymere, William, of Chetham 2
4657261 2248159 2248159 defendant Belle Simon husbandman 589479 589479 Belle, Simon, of Chetham, husbandman 0
4686820 2261489 2261489 defendant Gentilman John smith 589479 589479 Gentilman, John, of Chetham, smith 1
4795271 2294670 2294670 defendant Warner Thomas butcher 589479 589479 Warner, Thomas, of Chetham, butcher 0
4875827 2319402 2319402 defendant Lad Walter husbandman 589479 589479 Lad, Walter, of Chetham, husbandman 2
4894105 2324853 2324853 defendant Lad Walter   589479 589479 Lad, Walter, of Chetham, bailiff 0
4902205 2327298 2327298 defendant Forth William laborer 589479 589479 Forth, William, of Chetham, laborer 2
4906528 2328628 2328628 defendant Ladde Walter husbandman 589479 589479 Ladde, Walter, of Chetham, husbandman 0
5226509 2423417 2423417 defendant Gylle William laborer 589479 589479 Gylle, William, of Chetham juxta Rochester, laborer 0
5266371 2435233 2435233 defendant Lorkyn John husbandman 589479 589479 Lorkyn, John, of Chetham, husbandman 3
5348441 2459653 2459653 defendant Cacchelove John laborer 589479 589479 Cacchelove, John, of Chetham, laborer 6
5362000 2463778 2463778 defendant Knyght William husbandman 589479 589479 Knyght, William, of Chetham, husbandman 1
5362001 2463778 2463778 defendant Pilcher Walter husbandman 589479 589479 Pilcher, Walter, of Chetham, husbandman 2
5362002 2463778 2463778 defendant Lorkyn John husbandman 589479 589479 Lorkyn, John, of Chetham, husbandman 3
5364904 2464693 2464693 defendant Wodyer Thomas husbandman 589479 589479 Wodyer, Thomas, of Chetham, husbandman 1
5410226 2478010 2478010 defendant Cacchelove John husbandman 589479 589479 Cacchelove, John, of Chetham, husbandman 3
5478886 2498704 2498704 defendant Cacchelove John husbandman 589479 589479 Cacchelove, John, of Chetham, husbandman 3
5479452 2498871 2498871 defendant Wodyer Thomas husbandman 589479 589479 Wodyer, Thomas, of Chetham, husbandman 2
5520892 2511355 2511355 defendant Long Robert sawyer 589479 589479 Long, Robert, of Chetham, sawyer 0
5544948 2518528 2518528 defendant Riche Thomas husbandman 589479 589479 Riche, Thomas, of Chetham, husbandman 0
5595315 2533482 2533482 defendant Parson John husbandman 589479 589479 Parson, John, of Chetham, husbandman 0
5595318 2533483 2533483 defendant Parson John husbandman 589479 589479 Parson, John, of Chetham, husbandman 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);