names

41 rows where place_id = 595781

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621861 1874379 1874379 defendant Jonnes Thomas miller 595781 595781 Jonnes, Thomas, of Atherton, miller 0
3621862 1874379 1874379 defendant Jonnes Robert laborer 595781 595781 Jonnes, Robert, of Atherton, laborer 1
3747357 1941088 1941088 plaintiff Dyxson Nicholas   595781 595781 Dyxson, Nicholas, of Atherton 0
3747358 1941088 1941088 defendant Harres Richard butcher 595781 595781 Harres, Richard, of Atherton, butcher 0
3747359 1941088 1941088 defendant Barkeby Richard mercer 595781 595781 Barkeby, Richard, of Atherton, mercer 1
3747360 1941088 1941088 defendant Rampton John miller 595781 595781 Rampton, John, of Atherton, miller 2
3774748 1949831 1949831 defendant Hochynson alias Notyngham John mercer 595781 595781 Hochynson alias Notyngham, John, of Atherton, mercer 0
3785568 1953276 1953276 defendant Coke Thomas baker 595781 595781 Coke, Thomas, of Atherton, baker 0
3786650 1953619 1953619 defendant Pyers John husbandman 595781 595781 Pyers, John, of Atherton, husbandman 0
3786651 1953619 1953619 defendant Wavell John husbandman 595781 595781 Wavell, John, of Atherton, husbandman 1
3839629 1970318 1970318 defendant Coke Thomas baker 595781 595781 Coke, Thomas, of Atherton, baker 0
3880593 1983771 1983771 defendant Drayton Ralph butcher 595781 595781 Drayton, Ralph, of Atherton, butcher 0
3883999 1984918 1984918 defendant Hilley Robert shoemaker 595781 595781 Hilley, Robert, of Atherton, shoemaker 0
3884002 1984919 1984919 defendant Matany William   595781 595781 Matany, William, of Atherton, tallow chandler 0
3884785 1985187 1985187 defendant George Thomas yeoman 595781 595781 George, Thomas, of Atherton, yeoman 0
3896487 1989031 1989031 defendant Hochynson John mercer 595781 595781 Hochynson, John, of Atherton, mercer 1
3899030 1989881 1989881 defendant Fox William wheeler 595781 595781 Fox, William, of Atherton, wheeler 1
3917112 1996082 1996082 defendant Hochynson alias Notyngham John mercer 595781 595781 Hochynson alias Notyngham, John, of Atherton, mercer 0
3918309 1996459 1996459 defendant Grene Robert yeoman 595781 595781 Grene, Robert, of Atherton, yeoman 1
3919832 1996968 1996968 defendant Hylley Robert shoemkaer 595781 595781 Hylley, Robert, of Atherton, shoemkaer 1
4191209 2092490 2092490 defendant Hyndley William nailer 595781 595781 Hyndley, William, of Atherton, nailer 1
4327320 2139461 2139461 defendant Atherton Thomas gent 595781 595781 Atherton, Thomas, of Atherton, gent 1
4327321 2139461 2139461 defendant Hyndlay William nailer 595781 595781 Hyndlay, William, of Atherton, nailer 2
4327322 2139461 2139461 defendant Chowe or Cowes Arthur nailer 595781 595781 Chowe or Cowes, Arthur, of Atherton, nailer 3
4562811 2219927 2219927 defendant Kyng John   595781 595781 Kyng, John, of Atherton 2
4562817 2219928 2219928 defendant Kyng John   595781 595781 Kyng, John, of Atherton 3
4766664 2285565 2285565 defendant Gurmond John laborer 595781 595781 Gurmond, John, of Atherton, laborer 0
4766665 2285565 2285565 defendant Rammesdon Richard husbandman 595781 595781 Rammesdon, Richard, of Atherton, husbandman 1
4766668 2285565 2285565 defendant Stopard Thomas laborer 595781 595781 Stopard, Thomas, of Atherton, laborer 4
4766669 2285565 2285565 defendant Samburgh Thomas laborer 595781 595781 Samburgh, Thomas, of Atherton, laborer 5
5052591 2372369 2372369 defendant Draper Clement yeoman 595781 595781 Draper, Clement, of Atherton, yeoman 0
5226802 2423503 2423503 defendant Howe Thomas fuller 595781 595781 Howe, Thomas, of Atherton, fuller 0
5236529 2426270 2426270 defendant Waryn John   595781 595781 Waryn, John, of Atherton, servant 0
5236531 2426271 2426271 defendant Wareyn John   595781 595781 Wareyn, John, of Atherton, servant 0
5248410 2429664 2429664 defendant Howe Thomas fuller 595781 595781 Howe, Thomas, of Atherton, fuller 0
5311937 2448598 2448598 defendant Bate Thomas   595781 595781 Bate, Thomas, of Atherton, Mancetter, tallow chandler 0
5311938 2448598 2448598 defendant Vale William   595781 595781 Vale, William, of Atherton, Mancetter, tallow chandler 1
5563718 2523998 2523998 defendant Rede Richard yeoman 595781 595781 Rede, Richard, of Atherton, yeoman 0
5578488 2528343 2528343 defendant Agas Ralph laborer 595781 595781 Agas, Ralph, of Atherton, laborer 0
5578495 2528344 2528344 defendant Power Ralph tanner 595781 595781 Power, Ralph, of Atherton, tanner 0
5594197 2533162 2533162 plaintiff Barkeby John mercer 595781 595781 Barkeby, John, of Atherton, mercer 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);