names

77 rows where place_id = 591465

✎ 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
3604276 1869001 1869001 plaintiff Gilby Thomas (legal representative) 591465 591465 Gilby, Thomas, of Malberthorp, executors of 0
3604486 1869069 1869069 defendant Kent William (legal representative) 591465 591465 Kent, William, of Malberthorp, husbandman, executors of 0
3604488 1869069 1869069 defendant Kent Margaret widow 591465 591465 Kent, Margaret, of Malberthorp, widow 2
3619838 1873781 1873781 defendant Bolyngbroke John husbandman 591465 591465 Bolyngbroke, John, of Malberthorp, husbandman 0
3640164 1907368 1907368 defendant Bradley Robert husbandman 591465 591465 Bradley, Robert, of Malberthorp, husbandman 0
3640166 1907369 1907369 defendant Bradley William husbandman 591465 591465 Bradley, William, of Malberthorp, husbandman 0
3643029 1908268 1908268 defendant Bradley Robert yeoman 591465 591465 Bradley, Robert, of Malberthorp, yeoman 0
3713488 1930530 1930530 defendant Tregold James yeoman 591465 591465 Tregold, James, of Malberthorp, yeoman 1
3726669 1934603 1934603 plaintiff Tregold James   591465 591465 Tregold, James, of Malberthorp 0
4428478 2173723 2173723 defendant Gravne William le   591465 591465 Gravne, William le, of Malberthorp, son of Alexander 0
4476063 2193183 2193183 plaintiff Fosse William   591465 591465 Fosse, William, of Malberthorp 0
4518600 2206188 2206188 defendant Cheles Walter   591465 591465 Cheles, Walter, of Malberthorp 0
4518602 2206189 2206189 defendant Warner Robert   591465 591465 Warner, Robert, of Malberthorp 0
4522292 2207317 2207317 plaintiff Graneson John   591465 591465 Graneson, John, of Malberthorp 0
4553311 2216969 2216969 defendant Kydyer Richard   591465 591465 Kydyer, Richard, of Malberthorp 0
4560790 2219332 2219332 plaintiff Nyvery William   591465 591465 Nyvery, William, of Malberthorp 0
4584458 2226554 2226554 defendant Clerk Richard   591465 591465 Clerk, Richard, of Malberthorp 0
4604089 2232446 2232446 defendant Rolleston Thomas de   591465 591465 Rolleston, Thomas de, of Malberthorp 0
4614433 2235521 2235521 defendant Milner Richard   591465 591465 Milner, Richard, of Malberthorp 5
4630735 2240506 2240506 plaintiff Stutte John   591465 591465 Stutte, John, of Malberthorp 0
4630736 2240506 2240506 defendant Sowegrist William   591465 591465 Sowegrist, William, of Malberthorp 0
4678921 2259011 2259011 defendant Westryn John husbandman 591465 591465 Westryn, John, of Malberthorp, husbandman 0
4678922 2259011 2259011 defendant Wryght William laborer 591465 591465 Wryght, William, of Malberthorp, laborer 1
4681879 2259946 2259946 defendant Wynter Gilbert husbandman 591465 591465 Wynter, Gilbert, of Malberthorp, husbandman 3
4687857 2261767 2261767 plaintiff Stut or Scut John chaplain 591465 591465 Stut or Scut, John, of Malberthorp, chaplain 0
4713508 2269541 2269541 defendant Scalby Robert chaplain 591465 591465 (Scalby, Robert, of Malberthorp, chaplain 1
4721253 2271978 2271978 defendant Typsheth John gent 591465 591465 Typsheth, John, of Malberthorp, gent 0
4732323 2275288 2275288 defendant Lourdewyn John, sen husbandman 591465 591465 Lourdewyn, John, sen, of Malberthorp, husbandman 0
4742407 2278272 2278272 defendant Typsheth John gent 591465 591465 Typsheth, John, of Malberthorp, gent 0
4742761 2278389 2278389 defendant Wylkynson John husbandman 591465 591465 Wylkynson, John, of Malberthorp, husbandman 0
4767638 2285864 2285864 plaintiff Mauby John   591465 591465 Mauby, John, of Malberthorp 0
4791670 2293493 2293493 plaintiff Manby John   591465 591465 Manby, John, of Malberthorp 0
4806041 2298099 2298099 defendant Grayffin John husbandman 591465 591465 Grayffin, John, of Malberthorp, husbandman 2
4810759 2299488 2299488 defendant Lourdewyn William yeoman 591465 591465 Lourdewyn, William, of Malberthorp, yeoman 0
4817784 2301645 2301645 defendant Stut John husbandman 591465 591465 Stut, John, of Malberthorp, husbandman 0
4817785 2301645 2301645 defendant Lymber William husbandman 591465 591465 Lymber, William, of Malberthorp, husbandman 1
4819623 2302210 2302210 defendant Typstheth John   591465 591465 Typstheth, John, of Malberthorp, franklin 0
4850345 2311562 2311562 defendant Athymesse William husbandman 591465 591465 Athymesse, William, of Malberthorp, husbandman 0
4880131 2320696 2320696 defendant Ratheby Gilbert husbandman 591465 591465 Ratheby, Gilbert, of Malberthorp, husbandman 0
4890382 2323760 2323760 defendant Wynter Gilbert husbandman 591465 591465 Wynter, Gilbert, of Malberthorp, husbandman 6
4899026 2326337 2326337 defendant Coucher Adam husbandman 591465 591465 Coucher, Adam, of Malberthorp, husbandman 1
4923845 2333901 2333901 defendant Wynter Gilbert husbandman 591465 591465 Wynter, Gilbert, of Malberthorp, husbandman 1
4939877 2338860 2338860 defendant Nynery or Nyvery William husbandman 591465 591465 Nynery or Nyvery, William, of Malberthorp, husbandman 4
4939878 2338860 2338860 defendant Watkynson John husbandman 591465 591465 Watkynson, John, of Malberthorp, husbandman 5
4939879 2338860 2338860 defendant Wynter Gilbert husbandman 591465 591465 Wynter, Gilbert, of Malberthorp, husbandman 6
4939880 2338860 2338860 defendant Preston Thomas husbandman 591465 591465 Preston, Thomas, of Malberthorp, husbandman 7
4946872 2341029 2341029 defendant Nevery or Nenery John husbandman 591465 591465 Nevery or Nenery, John, of Malberthorp, husbandman 0
4980235 2351032 2351032 defendant Wynter Gilbert husbandman 591465 591465 Wynter, Gilbert, of Malberthorp, husbandman 3
4999218 2356638 2356638 defendant Typsheth William gent 591465 591465 Typsheth, William, of Malberthorp, gent 1
4999219 2356638 2356638 defendant Coucher John husbandman 591465 591465 Coucher, John, of Malberthorp, husbandman 2
5019009 2362451 2362451 defendant Gylby Nicholas husbandman 591465 591465 Gylby, Nicholas, of Malberthorp, husbandman 0
5026227 2364563 2364563 defendant Frankyssh John husbandman 591465 591465 Frankyssh, John, of Malberthorp, husbandman 2
5040897 2368896 2368896 defendant Coucher John husbandman 591465 591465 Coucher, John, of Malberthorp, husbandman 4
5064406 2375897 2375897 defendant Preston Thomas yeoman 591465 591465 Preston, Thomas, of Malberthorp, yeoman 1
5108751 2388996 2388996 defendant Aynderby Lawrence chaplain 591465 591465 Aynderby, Lawrence, of Malberthorp, chaplain 0
5125295 2393878 2393878 defendant Shake John, junior husbandman 591465 591465 Shake, John, junior, of Malberthorp, husbandman 0
5130831 2395499 2395499 defendant Stut Thomas clerk 591465 591465 Stut, Thomas, of Malberthorp, clerk 2
5135142 2396777 2396777 defendant Randson John husbandman 591465 591465 Randson, John, of Malberthorp, husbandman 1
5155249 2402684 2402684 defendant Randson John husbandman 591465 591465 Randson, John, of Malberthorp, husbandman 1
5164376 2405314 2405314 defendant Broun John husbandman 591465 591465 Broun, John, of Malberthorp, husbandman 1
5171954 2407511 2407511 defendant Rondson John husbandman 591465 591465 Rondson, John, of Malberthorp, husbandman 1
5189647 2412718 2412718 defendant Darry William dealer 591465 591465 Darry, William, of Malberthorp, dealer 0
5190751 2413046 2413046 defendant Roudson John husbandman 591465 591465 Roudson, John, of Malberthorp, husbandman 1
5236854 2426361 2426361 defendant Kyngeson John husbandman 591465 591465 Kyngeson, John, of Malberthorp, husbandman 0
5238748 2426924 2426924 defendant Aynderby Lawrence clerk 591465 591465 Aynderby, Lawrence, of Malberthorp, clerk 3
5280962 2439510 2439510 defendant Wythern Robert yeoman 591465 591465 Wythern, Robert, of Malberthorp, yeoman 0
5445631 2488582 2488582 defendant Pryntest Robert yeoman 591465 591465 Pryntest, Robert, of Malberthorp, yeoman 0
5458258 2492370 2492370 defendant Pryntoft Robert husbandman 591465 591465 Pryntoft, Robert, of Malberthorp, husbandman 0
5469894 2495920 2495920 defendant Pryntoft Robert husbandman 591465 591465 Pryntoft, Robert, of Malberthorp, husbandman 0
5515930 2509831 2509831 defendant Gilby Robert husbandman 591465 591465 Gilby, Robert, of Malberthorp, husbandman 0
5523214 2512090 2512090 defendant Johnson John husbandman 591465 591465 Johnson, John, of Malberthorp, husbandman 0
5541427 2517432 2517432 defendant Bullyngbroke John husbandman 591465 591465 Bullyngbroke, John, of Malberthorp, husbandman 2
5545204 2518598 2518598 defendant Holdernes Alan husbandman 591465 591465 Holdernes, Alan, of Malberthorp, husbandman 0
5555602 2521629 2521629 defendant Bullyngbroke Thomas husbandman 591465 591465 Bullyngbroke, Thomas, of Malberthorp, husbandman 0
5617865 2549404 2549404 plaintiff Lymner John   591465 591465 Lymner, John, of Malberthorp 0
5617885 2549411 2549411 plaintiff Lynmer John   591465 591465 Lynmer, John, of Malberthorp 0
5621826 2550735 2550735 defendant Ward Gilbert   591465 591465 Ward, Gilbert, of Malberthorp 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);