names

30 rows where place_id = 590764

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602248 1868367 1868367 defendant Mascall John yeoman 590764 590764 Mascall, John, of Chalfhunt, yeoman 5
4487536 2196819 2196819 plaintiff Smyth Simon   590764 590764 Smyth, Simon, of Chalfhunt St Peter 0
4487537 2196819 2196819 defendant Smyth Thomas   590764 590764 Smyth, Thomas, of Chalfhunt St Peter 0
4517277 2205803 2205803 defendant Lorkyn John   590764 590764 Lorkyn, John, of Chalfhunt 0
4520664 2206811 2206811 plaintiff Forster John   590764 590764 Forster, John, of Chalfhunt 0
4549406 2215759 2215759 defendant Forster John   590764 590764 Forster, John, of Chalfhunt 0
4564998 2220621 2220621 defendant Carpenter Thomas   590764 590764 Carpenter, Thomas, of Chalfhunt St Peter 0
4568386 2221683 2221683 defendant Raulyn John   590764 590764 Raulyn, John, of Chalfhunt St Peter 4
4663361 2250011 2250011 defendant Blakwell John maltman 590764 590764 Blakwell, John, of Chalfhunt, maltman 1
4663364 2250012 2250012 defendant Blakwell John maltman 590764 590764 Blakwell, John, of Chalfhunt, maltman 1
4981861 2351495 2351495 defendant Grove John husbandman 590764 590764 Grove, John, of Chalfhunt, husbandman 0
5143408 2399209 2399209 plaintiff Dunken Thomas   590764 590764 Dunken, Thomas, of Chalfhunt, parson & master 3
5143414 2399210 2399210 plaintiff Dimken or Dunken Thomas   590764 590764 Dimken or Dunken, Thomas, of Chalfhunt 3
5143423 2399211 2399211 plaintiff Dimken or Dunken Thomas   590764 590764 Dimken or Dunken, Thomas, of Chalfhunt 3
5178018 2409277 2409277 plaintiff Dunken Thomas   590764 590764 Dunken, Thomas, of Chalfhunt, parson & master 3
5178024 2409278 2409278 plaintiff Dunken Thomas master & parson 590764 590764 Dunken, Thomas, of Chalfhunt, master & parson 3
5178033 2409279 2409279 plaintiff Dunken Thomas master & parson 590764 590764 Dunken, Thomas, of Chalfhunt, master & parson 3
5178042 2409280 2409280 plaintiff Dunken Thomas master & parson 590764 590764 Dunken, Thomas, of Chalfhunt, master & parson 3
5201228 2416116 2416116 plaintiff Dunken Thomas master & parson 590764 590764 Dunken, Thomas, of Chalfhunt, master & parson 3
5201237 2416117 2416117 plaintiff Dunkens Thomas master & parson 590764 590764 Dunkens, Thomas, of Chalfhunt, master & parson 3
5232429 2425060 2425060 defendant Wheler Thomas   590764 590764 Wheler, Thomas, of Chalfhunt St Peter 0
5232432 2425061 2425061 defendant Wheler Thomas wheeler 590764 590764 Wheler, Thomas, of Chalfhunt St Peter, wheeler 0
5249503 2429967 2429967 defendant Lychefeld John husbandman 590764 590764 Lychefeld, John, of Chalfhunt St Peter, husbandman 1
5249888 2430079 2430079 defendant Wheler Thomas wheeler 590764 590764 Wheler, Thomas, of Chalfhunt St Peter, wheeler 0
5252323 2430836 2430836 defendant Hikkes John husbandman 590764 590764 Hikkes, John, of Chalfhunt St Peter, husbandman 2
5329364 2453866 2453866 defendant Harys Thomas yeoman 590764 590764 Harys, Thomas, of Chalfhunt, yeoman 4
5347396 2459348 2459348 defendant Fellep John cordwainer 590764 590764 Fellep, John, of Chalfhunt St Peter, cordwainer 1
5614460 2548315 2548315 defendant Spicer John   590764 590764 Spicer, John, of Chalfhunt St Peter 0
5630431 2553528 2553528 defendant Kempe Henry farmer 590764 590764 (Kempe, Henry, of Chalfhunt St Peter, farmer 4
5630432 2553528 2553528 defendant Dawes Thomas yeoman 590764 590764 Dawes, Thomas, of Chalfhunt St Peter, yeoman 5

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