names

30 rows where place_id = 594738

✎ 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
3617381 1873055 1873055 defendant Russell John yeoman 594738 594738 Russell, John, of Parshore, Worcs, yeoman 1
3631641 1904709 1904709 defendant Redyng Roger gent 594738 594738 Redyng, Roger, of Parshore, Worcs, gent 0
3650240 1910446 1910446 defendant Harrys John yeoman 594738 594738 Harrys, John, of Parshore, Worcs, yeoman 1
3705517 1928012 1928012 defendant Turve Richard yeoman 594738 594738 Turve, Richard, of Parshore, Worcs, yeoman 0
3705525 1928013 1928013 defendant Turve Richard yeoman 594738 594738 Turve, Richard, of Parshore, Worcs, yeoman 0
3794996 1956299 1956299 defendant Westerdale Christopher gent 594738 594738 Westerdale, Christopher, of Parshore, Worcs, gent 0
3804385 1959309 1959309 plaintiff Simons Robert yeoman 594738 594738 Simons, Robert, of Parshore, Worcs, yeoman 0
3810704 1961247 1961247 defendant Nevell Thomas esq 594738 594738 Nevell, Thomas, of Parshore, Worcs, esq 0
3822840 1965051 1965051 plaintiff Symons Robert yeoman 594738 594738 Symons, Robert, of Parshore, Worcs, yeoman 0
3839867 1970403 1970403 defendant Aleyn Richard yeoman 594738 594738 Aleyn, Richard, of Parshore, Worcs, yeoman 0
3954071 2008496 2008496 defendant Wautener or Wantener John mercer 594738 594738 Wautener or Wantener, John, of Parshore, Worcs, mercer 0
3957800 2009787 2009787 defendant Boxe alias Greville Giles yeoman 594738 594738 Boxe alias Greville, Giles, of Parshore, Worcs, yeoman 0
4036733 2037823 2037823 defendant Harryson Richard yeoman 594738 594738 Harryson, Richard, of Parshore, Worcs, yeoman 0
4216027 2101100 2101100 defendant Frenche Edward innholder 594738 594738 Frenche, Edward, of Parshore, Worcs, innholder 0
4233558 2107255 2107255 defendant Frenche Edward innholder 594738 594738 Frenche, Edward, of Parshore, Worcs, innholder 0
4300823 2130392 2130392 defendant Richardson Thomas gent 594738 594738 Richardson, Thomas, of Parshore, Worcs, gent 1
4308995 2133300 2133300 defendant Frenche Edward yeoman 594738 594738 Frenche, Edward, of Parshore, Worcs, yeoman 1
4309004 2133303 2133303 defendant Richardson Thomas gent 594738 594738 Richardson, Thomas, of Parshore, Worcs, gent 1
4354504 2148810 2148810 defendant Deacon Francis fishmonger 594738 594738 Deacon, Francis, of Parshore, Worcs, fishmonger 0
4387859 2160571 2160571 defendant Blonte John chapman 594738 594738 Blonte, John, of Parshore, Worcs, chapman 2
5497955 2504335 2504335 defendant Crompe Richard mercer 594738 594738 Crompe, Richard, of Parshore, Worcs, mercer 2
5532383 2514672 2514672 defendant Rudyng Roger gent 594738 594738 Rudyng, Roger, of Parshore, Worcs, gent 0
5546780 2519061 2519061 defendant Dalby William gent 594738 594738 Dalby, William, of Parshore, Worcs, gent 1
5549430 2519886 2519886 defendant Crumpe Margaret widow 594738 594738 Crumpe, Margaret, of Parshore, Worcs, widow 2
5551300 2520413 2520413 defendant Russell John mercer 594738 594738 Russell, John, of Parshore, Worcs, mercer 0
5564562 2524237 2524237 defendant Farley John gent 594738 594738 Farley, John, of Parshore, Worcs, gent 0
5564612 2524242 2524242 defendant Farley John gent 594738 594738 Farley, John, of Parshore, Worcs, gent 0
5584499 2530217 2530217 defendant Farley John yeoman 594738 594738 Farley, John, of Parshore, Worcs, yeoman 0
5593142 2532839 2532839 defendant Russell John, junior gent 594738 594738 Russell, John, junior, of Parshore, Worcs, gent 0
5593144 2532840 2532840 defendant Russell John, senior gent 594738 594738 Russell, John, senior, of Parshore, Worcs, gent 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);