names

38 rows where place_id = 596428

✎ 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
3624728 1875272 1875272 defendant Wyseman John gent 596428 596428 Wyseman, John, of Magna Thornham, gent 1
3625731 1875587 1875587 plaintiff Wyseman Simon (legal representative) 596428 596428 Wyseman, Simon, of Magna Thornham, esq, executor of 0
3625735 1875588 1875588 plaintiff Wyseman Simon (legal representative) 596428 596428 Wyseman, Simon, of Magna Thornham, esq, executor of 0
3684132 1921173 1921173 defendant Horne Thomas chaplain 596428 596428 Horne, Thomas, of Magna Thornham, chaplain 1
3718527 1932073 1932073 defendant Wyseman John   596428 596428 Wyseman, John, of Magna Thornham, knight 0
3726940 1934692 1934692 defendant Rede Isabel widow 596428 596428 Rede, Isabel, of Magna Thornham, widow 2
3734245 1936950 1936950 defendant Wyseman John   596428 596428 Wyseman, John, of Magna Thornham, knight 0
3742571 1939547 1939547 defendant Rede Isabel widow 596428 596428 Rede, Isabel, of Magna Thornham, widow 2
3855364 1975318 1975318 defendant Clerk Thomas husbandman 596428 596428 Clerk, Thomas, of Magna Thornham, husbandman 3
4856961 2313556 2313556 defendant Doraunt William husbandman 596428 596428 Doraunt, William, of Magna Thornham, husbandman 0
4882169 2321326 2321326 plaintiff Blyaunt Simon   596428 596428 Blyaunt, Simon, of Magna Thornham 2
4884032 2321916 2321916 plaintiff Blyaunt Simon   596428 596428 Blyaunt, Simon, of Magna Thornham 0
4899482 2326480 2326480 defendant Hunte Richard yeoman 596428 596428 Hunte, Richard, of Magna Thornham, yeoman 0
4937863 2338223 2338223 defendant Broun Thomas husbandman 596428 596428 Broun, Thomas, of Magna Thornham, husbandman 0
4937864 2338223 2338223 defendant Broun John husbandman 596428 596428 Broun, John, of Magna Thornham, husbandman 1
4937865 2338223 2338223 defendant Broun William husbandman 596428 596428 Broun, William, of Magna Thornham, husbandman 2
4937866 2338223 2338223 defendant Broun Robert husbandman 596428 596428 Broun, Robert, of Magna Thornham, husbandman 3
4937867 2338223 2338223 defendant Broun Nicholas husbandman 596428 596428 Broun, Nicholas, of Magna Thornham, husbandman 4
4941996 2339479 2339479 defendant Fent John yeoman 596428 596428 together with Fent, John, of Magna Thornham, yeoman 1
4941997 2339479 2339479 defendant Broun John yeoman 596428 596428 Broun, John, of Magna Thornham, yeoman 2
4942001 2339480 2339480 defendant Fent John yeoman 596428 596428 Fent, John, of Magna Thornham, yeoman 0
4942002 2339480 2339480 defendant Broun John yeoman 596428 596428 Broun, John, of Magna Thornham, yeoman 1
5014988 2361263 2361263 plaintiff Blyant Simon   596428 596428 Blyant, Simon, of Magna Thornham 0
5014991 2361264 2361264 plaintiff Blyaunt Simon   596428 596428 Blyaunt, Simon, of Magna Thornham 0
5323205 2452022 2452022 defendant Dunche John butcher 596428 596428 Dunche, John, of Magna Thornham, butcher 0
5341172 2457431 2457431 defendant Gede Richard laborer 596428 596428 Gede, Richard, of Magna Thornham, laborer 0
5532654 2514758 2514758 defendant Wyseman John gent 596428 596428 Wyseman, John, of Magna Thornham, gent 1
5532657 2514759 2514759 defendant Wyseman John gent 596428 596428 Wyseman, John,of Magna Thornham, gent 1
5533923 2515152 2515152 plaintiff Wyseman Simon (legal representative) 596428 596428 Wyseman, Simon, of Magna Thornham, esq, executor of 0
5547710 2519346 2519346 defendant Denny John husbandman 596428 596428 Denny, John, of Magna Thornham, husbandman 0
5547712 2519347 2519347 defendant Denny John husbandman 596428 596428 Denny, John, of Magna Thornham, husbandman 0
5547714 2519348 2519348 defendant Denny John husbandman 596428 596428 Denny, John, of Magna Thornham, husbandman 0
5562832 2523719 2523719 defendant Clerk Thomas yeoman 596428 596428 Clerk, Thomas, of Magna Thornham, yeoman 0
5571077 2526100 2526100 defendant Dunche Robert yeoman 596428 596428 Dunche, Robert, of Magna Thornham, yeoman 0
5599582 2534760 2534760 defendant Forde William yeoman 596428 596428 Forde, William, of Magna Thornham, yeoman 1
5599585 2534760 2534760 defendant Whyte John husbandman 596428 596428 Whyte, John, of Magna Thornham, husbandman 4
5607850 2537360 2537360 defendant Denny John yeoman 596428 596428 Denny, John, of Magna Thornham, yeoman 1
5608033 2537421 2537421 defendant Dunch John husbandman 596428 596428 Dunch, John, of Magna Thornham, 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);