names

51 rows where place_id = 606265

✎ 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
3664646 1914896 1914896 defendant Wonam John butcher 606265 606265 Wonam, John, of Kyngeston upon Thames, butcher 3
3664647 1914896 1914896 defendant Paper John   606265 606265 Paper, John, of Kyngeston upon Thames, inn holder 4
4446883 2183940 2183940 defendant Blake Walter   606265 606265 Blake, Walter, of Kyngeston upon Thames 3
4446892 2183942 2183942 defendant blake Walter   606265 606265 blake, Walter, of Kyngeston upon Thames 4
4458023 2187537 2187537 defendant Audren Thomas   606265 606265 Audren, Thomas, of Kyngeston upon Thames 0
4460710 2188408 2188408 defendant Wynge Robert   606265 606265 Wynge, Robert, of Kyngeston upon Thames 0
4545075 2214381 2214381 defendant Dorbarre Robert   606265 606265 Dorbarre, Robert, of Kyngeston upon Thames 1
4558203 2218506 2218506 defendant Dorbarre Robert   606265 606265 Dorbarre, Robert, of Kyngeston upon Thames 1
4565002 2220622 2220622 defendant Cheldwell Roger   606265 606265 Cheldwell, Roger, of Kyngeston upon Thames 0
4565004 2220623 2220623 defendant Cheldwell Roger   606265 606265 Cheldwell, Roger, of Kyngeston upon Thames 0
4574518 2223561 2223561 defendant Skynner Robert   606265 606265 Skynner, Robert, of Kyngeston upon Thames 0
4591226 2228613 2228613 defendant Mulsey William   606265 606265 Mulsey, William, of Kyngeston upon Thames 1
4591970 2228842 2228842 plaintiff Mylot Robert   606265 606265 Mylot, Robert, of Kyngeston upon Thames 0
4624839 2238748 2238748 defendant Thorp John   606265 606265 Thorp, John, of Kyngeston upon Thames 0
4625455 2238923 2238923 defendant Boteman William   606265 606265 Boteman, William, of Kyngeston upon Thames 0
4675526 2257957 2257957 plaintiff Forde William   606265 606265 Forde, William, of Kyngeston upon Thames 0
4678318 2258827 2258827 defendant Pyper Thomas   606265 606265 Pyper, Thomas, of Kyngeston upon Thames, pipe maker 1
4680448 2259498 2259498 defendant Forde William   606265 606265 Forde, William, of Kyngeston upon Thames 0
4682164 2260044 2260044 defendant atte Thele William skinner 606265 606265 atte Thele, William, of Kyngeston upon Thames, skinner 0
4717905 2270941 2270941 defendant Marchall Thomas fishmonger 606265 606265 Marchall, Thomas, of Kyngeston upon Thames, fishmonger 0
4721058 2271921 2271921 defendant Tewe John   606265 606265 Tewe, John, of Kyngeston upon Thames, arrow maker 0
4740955 2277864 2277864 defendant Rever William ironmonger 606265 606265 Rever, William, of Kyngeston upon Thames, ironmonger 0
4760265 2283562 2283562 defendant Lustyll Edward yeoman 606265 606265 Lustyll, Edward, of Kyngeston upon Thames, yeoman 4
4811555 2299722 2299722 defendant Warden John chapman 606265 606265 Warden, John, of Kyngeston upon Thames, chapman 2
4811883 2299830 2299830 defendant Wolf John husbandman 606265 606265 Wolf, John, of Kyngeston upon Thames, husbandman 0
4919587 2332629 2332629 defendant Bocher John butcher 606265 606265 Bocher, John, of Kyngeston upon Thames, butcher 0
4926948 2334858 2334858 plaintiff Richelot John husbandman 606265 606265 Richelot, John, of Kyngeston upon Thames, husbandman 0
5044804 2370081 2370081 defendant Fyssher John yeoman 606265 606265 Fyssher, John, of Kyngeston upon thames, yeoman 1
5046417 2370568 2370568 defendant Wolff John, senior husbandman 606265 606265 Wolff, John, senior, of Kyngeston upon Thames, husbandman 0
5135540 2396908 2396908 defendant Blamy William sawyer 606265 606265 Blamy, William, of Kyngeston upon Thames, sawyer 0
5188420 2412329 2412329 defendant Bartelot John   606265 606265 Bartelot, John, of Kyngeston upon Thames, shoe maker 0
5188421 2412329 2412329 defendant Symond Clement ostler 606265 606265 Symond, Clement, of Kyngeston upon Thames, ostler 1
5194473 2414112 2414112 defendant Bavell Richard yeoman 606265 606265 Bavell, Richard, of Kyngeston upon Thames, yeoman 0
5271964 2436883 2436883 defendant Testard Emenus tanner 606265 606265 Testard, Emenus, of Kyngeston upon Thames, tanner 0
5275413 2437876 2437876 defendant Wolsy John glover 606265 606265 Wolsy, John, of Kyngeston upon Thames, glover 0
5309276 2447811 2447811 defendant Fourde William yeoman 606265 606265 Fourde, William, of Kyngeston upon Thames, yeoman 0
5409056 2477674 2477674 defendant Brampton Richard gent 606265 606265 Brampton, Richard, of Kyngeston upon Thames, gent 0
5409058 2477675 2477675 defendant Brampton Richard gent 606265 606265 Brampton, Richard, of Kyngeston upon Thames, gent 0
5417240 2480071 2480071 plaintiff Orme William   606265 606265 Orme, William, of Kyngeston upon Thames 0
5417241 2480071 2480071 defendant Lee Robert gent 606265 606265 Lee, Robert, of Kyngeston upon Thames, gent 0
5422467 2481668 2481668 defendant Stone John butcher 606265 606265 Stone, John, of Kyngeston upon Thames, butcher 1
5422468 2481668 2481668 defendant Swyneshed William tailor 606265 606265 Swyneshed, William, of Kyngeston upon Thames, tailor 2
5425463 2482590 2482590 defendant Clerk Robert shoemaker 606265 606265 Clerk, Robert, of Kyngeston upon Thames, shoemaker 0
5426783 2482952 2482952 defendant Bromfeld Mathew carpenter 606265 606265 Bromfeld, Mathew, of Kyngeston upon Thames, carpenter 0
5438945 2486569 2486569 defendant Emmery John ostler 606265 606265 Emmery, John, of Kyngeston upon Thames, ostler 0
5445430 2488532 2488532 defendant Skern Robert   606265 606265 Skern, Robert, of Kyngeston upon Thames 0
5452830 2490726 2490726 defendant Emmery (illegible) ostler 606265 606265 Emmery, _, of Kyngeston upon Thames, ostler 0
5474727 2497423 2497423 defendant Chaundeler Nicholas yeoman 606265 606265 Chaundeler, Nicholas, of Kyngeston upon Thames, yeoman 0
5474729 2497424 2497424 defendant Deyman Thomas yeoman 606265 606265 Deyman, Thomas, of Kyngeston upon Thames, yeoman 0
5476264 2497909 2497909 defendant Emmery John   606265 606265 Emmery, John, of Kyngeston upon Thames 0
5608986 2537711 2537711 defendant Billy Walter miller 606265 606265 Billy, Walter, of Kyngeston upon Thames, miller 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);