names

27 rows where place_id = 591125

✎ 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
3603414 1868739 1868739 defendant Ferrour Edmund yeoman 591125 591125 Ferrour, Edmund, of Welburne, yeoman 3
3717470 1931748 1931748 defendant Cleyton Hugh smith 591125 591125 Cleyton, Hugh, of Welburne, smith 5
3780948 1951776 1951776 defendant Parker John husbandman 591125 591125 Parker, John, of Welburne, husbandman 2
3948456 2006523 2006523 defendant Uttyng Thomas husbandman 591125 591125 Uttyng, Thomas, of Welburne, husbandman 0
3948768 2006637 2006637 defendant Uttyng Thomas husbandman 591125 591125 Uttyng, Thomas, of Welburne, husbandman 1
3962715 2011543 2011543 defendant Uttyng Thomas husbandman 591125 591125 Uttyng, Thomas, of Welburne, husbandman 0
3962717 2011544 2011544 defendant Uttynge Thomas husbandman 591125 591125 Uttynge, Thomas, of Welburne, husbandman 0
3992233 2021986 2021986 defendant Worthyngton William gent 591125 591125 Worthyngton, William, of Welburne, gent 0
4013101 2029418 2029418 defendant Reade Robert husbandman 591125 591125 Reade, Robert, of Welburne, husbandman 0
4013826 2029675 2029675 defendant Reade Robert husbandman 591125 591125 Reade, Robert, of Welburne, husbandman 0
4015438 2030218 2030218 plaintiff Smyth William gent 591125 591125 Smyth, William, of Welburne, gent 0
4050718 2042690 2042690 defendant Worthyngton William gent 591125 591125 Worthyngton, William, of Welburne, gent 0
4058245 2045332 2045332 defendant Wylson John gent 591125 591125 Wylson, John, of Welburne, gent 0
4072344 2050410 2050410 defendant Beckingham William carpenter 591125 591125 Beckingham, William, of Welburne, carpenter 1
4119423 2067240 2067240 defendant Worthington Willian gent 591125 591125 Worthington, Willian, of Welburne, gent 1
4142393 2075512 2075512 defendant Worthington William gent 591125 591125 Worthington, William, of Welburne, gent 1
4202889 2096555 2096555 defendant Worthington William gent 591125 591125 Worthington, William, of Welburne, gent 0
4298226 2129467 2129467 defendant Awdley Robert gent 591125 591125 Awdley, Robert, of Welburne, gent 0
4401239 2165008 2165008 defendant Fairefax Nicholas gent 591125 591125 Fairefax, Nicholas, of Welburne, gent 2
4535255 2211293 2211293 defendant Mason William   591125 591125 Mason, William, of Welburne 0
4573350 2223196 2223196 defendant Letun John   591125 591125 Letun, John, of Welburne 1
4809088 2299019 2299019 defendant Derby John pedder 591125 591125 Derby, John, of Welburne, pedder 0
4826518 2304328 2304328 defendant Taillour John yeoman 591125 591125 Taillour, John, of Welburne, yeoman 12
5290109 2442113 2442113 defendant Mwndes or Munners William husbandman 591125 591125 Mwndes or Munners, William, of Welburne, husbandman 0
5368735 2465811 2465811 plaintiff Ferrour Edmund   591125 591125 Ferrour, Edmund, of Welburne 1
5435396 2485527 2485527 defendant Ferrour Richard yeoman 591125 591125 Ferrour, Richard, of Welburne, yeoman 0
5522463 2511845 2511845 defendant Multon Thomas yeoman 591125 591125 Multon, Thomas, of Welburne, yeoman 1

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