names

55 rows where place_id = 607010

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667325 1915718 1915718 defendant Preston Brian yeoman 607010 607010 Preston, Brian, of Rypon, Yorks, yeoman 0
3709055 1929131 1929131 defendant Tenant Robert gent 607010 607010 Tenant, Robert, of Rypon, Yorks, gent 0
3736278 1937586 1937586 defendant Norton John gent 607010 607010 Norton, John, of Rypon, Yorks, gent 2
3749564 1941775 1941775 defendant Norton John gent 607010 607010 Norton, John, of Rypon, Yorks, gent 1
3754481 1943358 1943358 defendant Preston alias Bryston Brian yeoman 607010 607010 Preston alias Bryston, Brian, of Rypon, Yorks, yeoman 1
3762898 1946031 1946031 defendant Jelybrond Edmund yeoman 607010 607010 Jelybrond, Edmund, of Rypon, Yorks, yeoman 0
3762903 1946032 1946032 defendant Jolybrond Edmund yeoman 607010 607010 Jolybrond, Edmund, of Rypon, Yorks, yeoman 0
3835427 1969019 1969019 defendant Webbe alias Constable Marmaduke clerk 607010 607010 Webbe alias Constable, Marmaduke, of Rypon, Yorks, clerk 1
3839055 1970139 1970139 defendant Walden alias Constable Marmaduke clerk 607010 607010 Walden alias Constable, Marmaduke, of Rypon, Yorks, clerk 5
3874438 1981680 1981680 defendant Melebanke Robert chapman 607010 607010 Melebanke, Robert, of Rypon, Yorks, chapman 0
3918777 1996608 1996608 defendant Norton Henry (legal representative) 607010 607010 Norton, Henry, of Rypon, Yorks, esq, administrator of 1
4119283 2067189 2067189 defendant Johnson Christopher yeoman 607010 607010 Johnson, Christopher, of Rypon, Yorks, yeoman 1
4125388 2069364 2069364 defendant Tratt Thomas chapman 607010 607010 Tratt, Thomas, of Rypon, Yorks, chapman 0
4673010 2257203 2257203 defendant Lane William husbandman 607010 607010 Lane, William, of Rypon, Yorks, husbandman 0
4720002 2271602 2271602 defendant Revaux William mercer 607010 607010 Revaux, William, of Rypon, Yorks, mercer 0
4736781 2276633 2276633 defendant Walthewe Thomas yeoman 607010 607010 Walthewe, Thomas, of Rypon, Yorks, yeoman 0
4744652 2278956 2278956 defendant snaythe Robert esq 607010 607010 snaythe, Robert, of Rypon, Yorks, esq 6
4745380 2279157 2279157 defendant Wrampayn William, senior chapman 607010 607010 Wrampayn, William, senior, of Rypon, Yorks, chapman 1
4750038 2280484 2280484 defendant Goldherd Peter yeoman 607010 607010 Goldherd, Peter, of Rypon, Yorks, yeoman 0
4776494 2288643 2288643 defendant Wethirby John chapman 607010 607010 Wethirby, John, of Rypon, Yorks, chapman 0
4794411 2294394 2294394 defendant Stowe William gent 607010 607010 Stowe, William, of Rypon, Yorks, gent 0
4794415 2294395 2294395 defendant Wadeloffe John yeoman 607010 607010 Wadeloffe, John, of Rypon, Yorks, yeoman 0
4794418 2294396 2294396 defendant Gelherd Peter yeoman 607010 607010 Gelherd, Peter, of Rypon, Yorks, yeoman 0
4794442 2294401 2294401 defendant Wadeloffe John yeoman 607010 607010 Wadeloffe, John, of Rypon, Yorks, yeoman 0
4799213 2295935 2295935 defendant de Watir John merchant 607010 607010 de Watir, John, of Rypon, Yorks, merchant 0
4803939 2297412 2297412 defendant Taverner Robert gent 607010 607010 Taverner, Robert, of Rypon, Yorks, gent 0
4817468 2301552 2301552 defendant Wederby John de merchant 607010 607010 Wederby, John de, of Rypon, Yorks, merchant 0
4939775 2338828 2338828 defendant Snayth Robert forester 607010 607010 Snayth, Robert, of Rypon, Yorks, forester 2
4939782 2338830 2338830 defendant Snayth Robert forester 607010 607010 Snayth, Robert, of Rypon, Yorks, forester 2
4946509 2340901 2340901 defendant Laton Robert esq 607010 607010 Laton, Robert, of Rypon, Yorks, esq 3
4959250 2344735 2344735 defendant Turnour Robert merchant 607010 607010 Turnour, Robert, of Rypon, Yorks, merchant 0
5039959 2368595 2368595 defendant Percyvall John gent 607010 607010 Percyvall, John, of Rypon, Yorks, gent 0
5045420 2370259 2370259 defendant Smale John smith 607010 607010 Smale, John, of Rypon, Yorks, smith 2
5061752 2375110 2375110 defendant Whetherby John mercer 607010 607010 Whetherby, John, of Rypon, Yorks, mercer 2
5071650 2378014 2378014 defendant Flesshewer John dyer 607010 607010 Flesshewer, John, of Rypon, Yorks, dyer 1
5117889 2391661 2391661 defendant Chapman Richard chapman 607010 607010 Chapman, Richard, of Rypon, Yorks, chapman 0
5127805 2394609 2394609 defendant Kyrkeby John dyer 607010 607010 Kyrkeby, John, of Rypon, Yorks, dyer 2
5150127 2401177 2401177 defendant Croke William shoemaker 607010 607010 Croke, William, of Rypon, Yorks, shoemaker 0
5176223 2408735 2408735 defendant Thomson John butcher 607010 607010 Thomson, John, of Rypon, Yorks, butcher 5
5176224 2408735 2408735 defendant Lytton Robert butcher 607010 607010 Lytton, Robert, of Rypon, Yorks, butcher 6
5226908 2423528 2423528 defendant Clerk William gent 607010 607010 Clerk, William, of Rypon, Yorks, gent 1
5268283 2435845 2435845 defendant Croser John merchant & Alderman of York 607010 607010 Croser, John, of Rypon, Yorks, merchant & Alderman of York 0
5268286 2435846 2435846 defendant Croser John merchant & Alderman of York 607010 607010 Croser, John, of Rypon, Yorks, merchant & Alderman of York 0
5326747 2453068 2453068 defendant Pygott John esq 607010 607010 Pygott, John, of Rypon, Yorks, esq 0
5343732 2458223 2458223 defendant Burgh Robert chapman 607010 607010 Burgh, Robert, of Rypon, Yorks, chapman 1
5392790 2473006 2473006 defendant Parker Roland gent 607010 607010 Parker, Roland, of Rypon, Yorks, gent 2
5403789 2476157 2476157 defendant Ulthwayt John   607010 607010 Ulthwayt, John, of Rypon, Yorks, mason 3
5416942 2479980 2479980 defendant Ulthwayt John   607010 607010 Ulthwayt, John, of Rypon, Yorks, mason 3
5433894 2485099 2485099 defendant Rand Thomas butcher 607010 607010 Rand, Thomas, of Rypon, Yorks, butcher 0
5433930 2485104 2485104 defendant Rand Thomas butcher 607010 607010 Rand, Thomas, of Rypon, Yorks, butcher 0
5434033 2485131 2485131 defendant Ulthwayt John   607010 607010 Ulthwayt, John, of Rypon, Yorks, mason 3
5463433 2493973 2493973 defendant Wryght John clerk 607010 607010 Wryght, John, of Rypon, Yorks, clerk 1
5522993 2512018 2512018 defendant Cok Thomas chapman 607010 607010 Cok, Thomas, of Rypon, Yorks, chapman 0
5580663 2529033 2529033 defendant Newman Andrew clerk 607010 607010 Newman, Andrew, of Rypon, Yorks, clerk 0
5596247 2533741 2533741 defendant Newman Andrew clerk 607010 607010 Newman, Andrew, of Rypon, yorks, clerk 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);