names

41 rows where place_id = 600920

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643147 1908295 1908295 defendant Abyngham Richard husbandman 600920 600920 Abyngham, Richard, of Nutfeld, husbandman 1
3649273 1910161 1910161 defendant Clement John wheeler 600920 600920 Clement, John, of Nutfeld, wheeler 0
3775262 1949999 1949999 defendant Laker Thomas husbandman 600920 600920 Laker, Thomas, of Nutfeld, husbandman 0
3786580 1953598 1953598 defendant Laker Robert husbandman 600920 600920 Laker, Robert, of Nutfeld, husbandman 0
3786585 1953600 1953600 defendant Jameson William clerk 600920 600920 Jameson, William, of Nutfeld, clerk 1
3804564 1959368 1959368 defendant Mylys John, senior laborer 600920 600920 Mylys, John, senior, of Nutfeld, laborer 0
3804565 1959368 1959368 defendant Milis John, junior laborer 600920 600920 Milis, John, junior, of Nutfeld, laborer 1
3804566 1959368 1959368 defendant Phelypp Richard tailor 600920 600920 Phelypp, Richard, of Nutfeld, tailor 2
3804567 1959368 1959368 defendant Choll William laborer 600920 600920 Choll, William, of Nutfeld, laborer 3
3804569 1959369 1959369 defendant Mylys John, senior laborer 600920 600920 Mylys, John, senior, of Nutfeld, laborer 0
3804570 1959369 1959369 defendant Mylys John, junior laborer 600920 600920 Mylys, John, junior, of Nutfeld, laborer 1
3804571 1959369 1959369 defendant Phelypp Richard tailor 600920 600920 Phelypp, Richard, of Nutfeld, tailor 2
3804572 1959369 1959369 defendant Choll William laborer 600920 600920 Choll, William, of Nutfeld, laborer 3
3811105 1961370 1961370 defendant Estwode John husbandman 600920 600920 Estwode, John, of Nutfeld, husbandman 0
4189762 2091914 2091914 defendant Geale or Jeale William yeoman 600920 600920 Geale or Jeale, William, of Nutfeld, or of Caterham, yeoman 0
4227860 2105226 2105226 defendant Jeale William yeoman 600920 600920 Jeale, William, of Nutfeld, yeoman 0
4233239 2107137 2107137 defendant Jeale William yeoman 600920 600920 Jeale, William, of Nutfeld, yeoman 0
4233240 2107137 2107137 defendant Jeale Nicholas yeoman 600920 600920 Jeale, Nicholas, of Nutfeld, yeoman 1
4235698 2108052 2108052 defendant Jeale or Geale William yeoman 600920 600920 Jeale or Geale, William, of Nutfeld, yeoman 0
4236646 2108391 2108391 defendant Jeale William yeoman 600920 600920 Jeale, William, of Nutfeld, yeoman 0
4309543 2133497 2133497 defendant Woodman John husbandman 600920 600920 Woodman, John, of Nutfeld, husbandman 1
4322244 2137855 2137855 defendant Jeale or Geale William yeoman 600920 600920 Jeale or Geale, William, of Nutfeld, yeoman 0
4322247 2137856 2137856 defendant Jeale or Geale William yeoman 600920 600920 Jeale or Geale, William, of Nutfeld, yeoman 0
4322250 2137857 2137857 defendant Jeale William husbandman 600920 600920 Jeale, William, of Nutfeld, husbandman 0
4322251 2137857 2137857 defendant Jeale Nicholas husbandman 600920 600920 Jeale, Nicholas, of Nutfeld, husbandman 1
4339136 2143445 2143445 defendant Jeale Nicholas yeoman 600920 600920 Jeale, Nicholas, of Nutfeld, yeoman 0
4358512 2150212 2150212 defendant Jeale William yeoman 600920 600920 Jeale, William, of Nutfeld, yeoman 0
4368941 2153951 2153951 defendant Jeale or Geale Nicholas yeoman 600920 600920 Jeale or Geale, Nicholas, of Nutfeld, yeoman 0
4368943 2153952 2153952 defendant Jeale William yeoman 600920 600920 Jeale, William, of Nutfeld, yeoman 0
4412865 2168897 2168897 defendant Jeale Nicholas yeoman 600920 600920 Jeale, Nicholas, of Nutfeld, yeoman 0
4806402 2298212 2298212 defendant atte Hethe Robert husbandman 600920 600920 atte Hethe, Robert, of Nutfeld, husbandman 0
4970663 2348162 2348162 defendant Kyllyk Richard husbandman 600920 600920 Kyllyk, Richard, of Nutfeld, husbandman 0
4991434 2354323 2354323 defendant atte Hethe Robert husbandman 600920 600920 atte Hethe, Robert, of Nutfeld, husbandman 1
5011117 2360103 2360103 defendant Bone Thomas yeoman 600920 600920 Bone, Thomas, of Nutfeld, yeoman 1
5014490 2361100 2361100 defendant Cheseman Richard husbandman 600920 600920 Cheseman, Richard, of Nutfeld, husbandman 1
5014491 2361100 2361100 defendant Hale John husbandman 600920 600920 Hale, John, of Nutfeld, husbandman 2
5071190 2377879 2377879 defendant Myles John, junior husbandman 600920 600920 Myles, John, junior, of Nutfeld, husbandman 4
5180496 2410041 2410041 defendant atte Tye John husbandman 600920 600920 atte Tye, John, of Nutfeld, husbandman 0
5180498 2410042 2410042 defendant Pacheman Henry butcher 600920 600920 Pacheman, Henry, of Nutfeld, butcher 0
5454727 2491336 2491336 defendant Gantron John husbandman 600920 600920 Gantron, John, of Nutfeld, husbandman 0
5544705 2518454 2518454 defendant Miles Richard husbandman 600920 600920 Miles, Richard, of Nutfeld, 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);