names

74 rows where place_id = 587024

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590275 1864603 1864603 defendant Waren Thomas butcher 587024 587024 Waren, Thomas, of Stratford atte Bowe, Middx, butcher 1
3590281 1864604 1864604 defendant Waren Thomas butcher 587024 587024 Waren, Thomas, of Stratford atte Bowe, Middx, butcher 0
3592361 1865226 1865226 defendant Waren Thomas butcher 587024 587024 Waren, Thomas, of Stratford atte Bowe, Middx, butcher 1
3593100 1865470 1865470 defendant Watson Thomas miller 587024 587024 Watson, Thomas, of Stratford atte Bowe, Middx, miller 0
3599577 1867505 1867505 defendant Waren Thomas butcher 587024 587024 Waren, Thomas, of Stratford atte Bowe, Middx, butcher 0
3604197 1868978 1868978 defendant Berfote Robert yeoman 587024 587024 Berfote, Robert, of Stratford atte Bowe, Middx, yeoman 1
3604202 1868979 1868979 defendant Barfote Robert yeoman 587024 587024 Barfote, Robert, of Stratford atte Bowe, Middx, yeoman 2
4589508 2228092 2228092 defendant fitz or Brwer John   587024 587024 fitz or Brwer, John, of Stratford atte Bowe, Middx 4
4640688 2243382 2243382 plaintiff Edmund John miller 587024 587024 Edmund, John, of Stratford atte Bowe, Middx, miller 0
4681204 2259747 2259747 defendant Skelton Thomas yeoman 587024 587024 Skelton, Thomas, of Stratford atte Bowe, Middx, yeoman 3
4686380 2261345 2261345 defendant Davenys Richard laborer 587024 587024 Davenys, Richard, of Stratford atte Bowe, Middx, laborer 2
4755322 2282053 2282053 defendant Haynes Roger chaplain 587024 587024 Haynes, Roger, of Stratford atte Bowe, Middx, chaplain 0
4771290 2287002 2287002 defendant Childe William fuller 587024 587024 Childe, William, of Stratford atte Bowe, Middx, fuller 0
4799003 2295861 2295861 defendant Nyghtyngale John baker 587024 587024 Nyghtyngale, John, of Stratford atte Bowe, Middx, baker 2
4799008 2295862 2295862 defendant Nightynggale John baker 587024 587024 Nightynggale, John, of Stratford atte Bowe, Middx, baker 2
4803116 2297164 2297164 defendant Walker Richard walker 587024 587024 Walker, Richard, of Stratford atte Bowe, Middx, walker 0
4836089 2307269 2307269 plaintiff Edemond John   587024 587024 Edemond, John, of Stratford atte Bowe, Middx, baker, administrators of 0
4836095 2307269 2307269 defendant Albryght William yeoman 587024 587024 Albryght, William, of Stratford atte Bowe, Middx, yeoman 1
4866167 2316389 2316389 defendant Notyngham alias Grene Mary widow 587024 587024 Notyngham alias Grene, Mary, of Stratford atte Bowe, Middx, widow 0
4902156 2327285 2327285 defendant Rondwhete John husbandman 587024 587024 Rondwhete, John, of Stratford atte Bowe, Middx, husbandman 0
4931346 2336183 2336183 defendant Gybbys John yeoman 587024 587024 Gybbys, John, of Stratford atte Bowe, Middx, yeoman 2
4952783 2342789 2342789 defendant Alcok Richard yeoman 587024 587024 Alcok, Richard, of Stratford atte Bowe, Middx, yeoman 1
4954048 2343174 2343174 defendant Alcok Richard chapman 587024 587024 Alcok, Richard, of Stratford atte Bowe, Middx, chapman 0
4954883 2343416 2343416 defendant Stikkere John baker 587024 587024 Stikkere, John, of Stratford atte Bowe, Middx, baker 0
4959001 2344658 2344658 defendant Haywod William brewer 587024 587024 Haywod, William, of Stratford atte Bowe, Middx, brewer 1
4994301 2355168 2355168 defendant Pygot Edmund husbandman 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, husbandman 1
4994304 2355169 2355169 defendant Pygot Edmund husbandman 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, husbandman 1
4999763 2356806 2356806 defendant Woderove John yeoman 587024 587024 Woderove, John, of Stratford atte Bowe, Middx, yeoman 1
4999766 2356807 2356807 defendant Woderove John yeoman 587024 587024 Woderove, John, of Stratford atte Bowe, Middx, yeoman 1
5014866 2361226 2361226 defendant Lokwode Robert baker 587024 587024 Lokwode, Robert, of Stratford atte Bowe, Middx, baker 2
5023465 2363772 2363772 defendant Oxton Robert yeoman 587024 587024 Oxton, Robert, of Stratford atte Bowe, Middx, yeoman 0
5054760 2373000 2373000 defendant Barton Thomas yeoman 587024 587024 (Barton, Thomas, of Stratford atte Bowe, Middx, yeoman 1
5055869 2373323 2373323 defendant Burdon Thomas baker 587024 587024 Burdon, Thomas, of Stratford atte Bowe, Middx, baker 0
5077832 2379861 2379861 defendant Barton Thomas yeoman 587024 587024 (Barton, Thomas, of Stratford atte Bowe, Middx, yeoman 1
5106223 2388258 2388258 defendant Warde Thomas butcher 587024 587024 Warde, Thomas, of Stratford atte Bowe, Middx, butcher 3
5106228 2388259 2388259 defendant Warde Thomas butcher 587024 587024 Warde, Thomas, of Stratford atte Bowe, Middx, butcher 3
5107979 2388775 2388775 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 0
5110195 2389387 2389387 defendant Pygot Edmund husbandman 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, husbandman 3
5114484 2390634 2390634 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 0
5120732 2392491 2392491 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 0
5124335 2393565 2393565 plaintiff Yorke John baker 587024 587024 Yorke, John, of Stratford atte Bowe, Middx, baker 0
5158410 2403580 2403580 defendant Browne John gent alias of the duke of Exeter's hospice 587024 587024 Browne, John, of Stratford atte Bowe, Middx, gent alias of the duke of Exeter's hospice 0
5158416 2403582 2403582 defendant Broun John gent of the hospice of the Duke of Exeter 587024 587024 Broun, John, of Stratford atte Bowe, Middx, gent of the hospice of the Duke of Exeter 0
5176855 2408920 2408920 defendant Lewes Philip   587024 587024 Lewes, Philip, of Stratford atte Bowe, Middx, servant 0
5199394 2415573 2415573 defendant Lewes Philip   587024 587024 Lewes, Philip, of Stratford atte Bowe, Middx, servant 0
5224347 2422795 2422795 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 0
5224364 2422801 2422801 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 1
5225127 2423020 2423020 defendant Pygot Edmund brewer 587024 587024 Pygot, Edmund, of Stratford atte Bowe, Middx, brewer 0
5253461 2431184 2431184 defendant Brook Richard barber 587024 587024 Brook, Richard, of Stratford atte Bowe, Middx, barber 2
5283880 2440316 2440316 defendant Rowe John fuller 587024 587024 Rowe, John, of Stratford atte Bowe, Middx, fuller 0
5283882 2440317 2440317 defendant Rowe John fuller 587024 587024 Rowe, John, of Stratford atte Bowe, Middx, fuller 0
5292459 2442792 2442792 plaintiff Rotheley William baker 587024 587024 Rotheley, William, of Stratford atte Bowe, Middx, baker 0
5317046 2450174 2450174 defendant Radley William baker 587024 587024 Radley, William, of Stratford atte Bowe, Middx, baker 0
5323792 2452200 2452200 defendant Yorke John widow 587024 587024 Yorke, John, of Stratford atte Bowe, Middx, widow 1
5324973 2452548 2452548 plaintiff Rotheley William baker 587024 587024 Rotheley, William, of Stratford atte Bowe, Middx, baker 0
5331367 2454459 2454459 defendant Bell Margaret widow 587024 587024 Bell, Margaret, of Stratford atte Bowe, Middx, widow 1
5339987 2457078 2457078 defendant Burges John miler 587024 587024 Burges, John, of Stratford atte Bowe, Middx, miler 2
5360940 2463446 2463446 defendant Rodley William baker 587024 587024 Rodley, William, of Stratford atte Bowe, Middx, baker 2
5372700 2467062 2467062 defendant Hoke John butcher 587024 587024 Hoke, John, of Stratford atte Bowe, Middx, butcher 0
5377386 2468516 2468516 defendant Riddeley William brewer 587024 587024 Riddeley, William, of Stratford atte Bowe, Middx, brewer 0
5437115 2486037 2486037 defendant Lie John brewer 587024 587024 Lie, John, of Stratford atte Bowe, Middx, brewer 0
5451574 2490346 2490346 defendant (illegible) John draper 587024 587024 _, John, of Stratford atte Bowe, Middx, draper 0
5451607 2490352 2490352 defendant Blythe William miller 587024 587024 Blythe, William, of Stratford atte Bowe, Middx, miller 3
5451615 2490354 2490354 defendant Lye John brewer 587024 587024 Lye, John, of Stratford atte Bowe, Middx, brewer 0
5482232 2499627 2499627 defendant Hooke John butcher 587024 587024 Hooke, John, of Stratford atte Bowe, Middx, butcher 0
5494713 2503308 2503308 defendant Waren Thomas butcher 587024 587024 Waren, Thomas, of Stratford atte Bowe, Middx, butcher 3
5511889 2508574 2508574 defendant Papde Alexander founder 587024 587024 Papde, Alexander, of Stratford atte Bowe, Middx, founder 0
5511891 2508575 2508575 defendant Papde Alexander founder 587024 587024 Papde, Alexander, of Stratford Atte Bowe, Middx, founder 0
5527054 2513030 2513030 defendant Canon John, senior baker 587024 587024 Canon, John, senior, of Stratford atte Bowe, Middx, baker 1
5531290 2514304 2514304 defendant Sturmyn John baker 587024 587024 Sturmyn, John, of Stratford atte Bowe, Middx, baker 0
5584894 2530354 2530354 plaintiff Higoun Mathew tailor 587024 587024 Higoun, Mathew, of Stratford atte Bowe, Middx, tailor 0
5585443 2530516 2530516 plaintiff Hygon Mathew tailor 587024 587024 Hygon, Mathew, of Stratford atte Bowe, Middx, tailor 0
5629197 2553107 2553107 defendant Dyere William dyer 587024 587024 Dyere, William, of Stratford atte Bowe, Middx, dyer 3
5629203 2553108 2553108 defendant Dyere William dyer 587024 587024 Dyere, William, of Stratford atte Bowe, Middx, dyer 3

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