names

82 rows where place_id = 590942

✎ 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
3602778 1868535 1868535 defendant Haklton John yeoman 590942 590942 Haklton, John, of Swyndon, yeoman 0
3602785 1868538 1868538 defendant Halton John yeoman 590942 590942 Halton, John, of Swyndon, yeoman 0
3603565 1868785 1868785 defendant Rostrop John yeoman 590942 590942 Rostrop, John, of Swyndon, yeoman 0
3603566 1868785 1868785 defendant Rostrop Walter yeoman 590942 590942 Rostrop, Walter, of Swyndon, yeoman 1
3616314 1872741 1872741 defendant Holwey William husbandman 590942 590942 Holwey, William, of Swyndon, husbandman 0
3643594 1908428 1908428 defendant Carter Richard yeoman 590942 590942 Carter, Richard, of Swyndon, yeoman 0
3643595 1908428 1908428 defendant Roo Richard draper 590942 590942 Roo, Richard, of Swyndon, draper 1
3643596 1908428 1908428 defendant Stephen William yeoman 590942 590942 Stephen, William, of Swyndon, yeoman 2
3678971 1919493 1919493 defendant Reve Robert husbandman 590942 590942 Reve, Robert, of Swyndon, husbandman 0
3713519 1930539 1930539 defendant Wyltshyre Nicholas husbandman 590942 590942 Wyltshyre, Nicholas, of Swyndon, husbandman 0
3715408 1931104 1931104 defendant Fermour William husbandman 590942 590942 Fermour, William, of Swyndon, husbandman 0
3752239 1942622 1942622 defendant Smyth alias Baker Thomas baker 590942 590942 Smyth alias Baker, Thomas, of Swyndon, baker 2
3826149 1966021 1966021 defendant Brether William husbandman 590942 590942 Brether, William, of Swyndon, husbandman 0
3826150 1966021 1966021 defendant Brether Richard husbandman 590942 590942 Brether, Richard, of Swyndon, husbandman 1
3826151 1966021 1966021 defendant Gwyn William husbandman 590942 590942 Gwyn, William, of Swyndon, husbandman 2
3826152 1966021 1966021 defendant Smyth John husbandman 590942 590942 Smyth, John, of Swyndon, husbandman 3
3834275 1968665 1968665 defendant Browne John gent 590942 590942 Browne, John, of Swyndon, gent 0
3882128 1984280 1984280 defendant Kyng alias Mydwynter Richard butcher 590942 590942 Kyng alias Mydwynter, Richard, of Swyndon, butcher 0
3886836 1985859 1985859 defendant Stytchall Anthony husbandman 590942 590942 Stytchall, Anthony, of Swyndon, husbandman 0
3900847 1990512 1990512 defendant Stytchall Anthony husbandman 590942 590942 Stytchall, Anthony, of Swyndon, husbandman 0
3909922 1993626 1993626 defendant Champerlayne John husbandman 590942 590942 Champerlayne, John, of Swyndon, husbandman 0
3909923 1993626 1993626 defendant Fernner Richard, junior husbandman 590942 590942 Fernner, Richard, junior, of Swyndon, husbandman 1
3938923 2003353 2003353 plaintiff Robardes Thomas clerk 590942 590942 Robardes, Thomas, of Swyndon, clerk 0
3977804 2016808 2016808 defendant Hochekis or Hoskys John weaver 590942 590942 Hochekis or Hoskys, John, of Swyndon, weaver 0
4016211 2030496 2030496 plaintiff Stephens Nicholas husbandman 590942 590942 Stephens, Nicholas, of Swyndon, husbandman 0
4047469 2041546 2041546 plaintiff Stephyns Nicholas husbandman 590942 590942 Stephyns, Nicholas, of Swyndon, husbandman 0
4125298 2069332 2069332 defendant Johnson James yeoman 590942 590942 Johnson, James, of Swyndon, yeoman 1
4132312 2071870 2071870 defendant Bathe John husbandman 590942 590942 Bathe, John, of Swyndon, husbandman 1
4282250 2123691 2123691 defendant Baker John gent 590942 590942 Baker, John, of Swyndon, gent 0
4333654 2141536 2141536 defendant Ellyott Walter carpenter 590942 590942 Ellyott, Walter, of Swyndon, carpenter 0
4333655 2141536 2141536 defendant Grene Thomas husbandman 590942 590942 Grene, Thomas, of Swyndon, husbandman 1
4333656 2141536 2141536 defendant Phillipps   husbandman 590942 590942 Phillipps, , of Swyndon, husbandman 2
4413230 2169009 2169009 defendant Moren Simon   590942 590942 Moren, Simon, of Swyndon 0
4433312 2175173 2175173 defendant Muleward John le   590942 590942 Muleward, John le, of Swyndon 1
4447239 2184046 2184046 plaintiff Dyere John   590942 590942 Dyere, John, of Swyndon 0
4447248 2184047 2184047 plaintiff Dyere John   590942 590942 Dyere, John, of Swyndon 0
4474019 2192526 2192526 defendant Sherman John   590942 590942 Sherman, John, of Swyndon 0
4474354 2192631 2192631 plaintiff Deyere Richard   590942 590942 Deyere, Richard, of Swyndon, parson 0
4492564 2198372 2198372 defendant Dier John   590942 590942 Dier, John, of Swyndon 0
4492565 2198372 2198372 defendant Bocher Richard   590942 590942 Bocher, Richard, of Swyndon 1
4496378 2199543 2199543 defendant Dyer John   590942 590942 Dyer, John, of Swyndon 2
4496379 2199543 2199543 defendant Bocher Richard   590942 590942 Bocher, Richard, of Swyndon 3
4511797 2204135 2204135 defendant Boundy John   590942 590942 Boundy, John, of Swyndon 0
4543090 2213725 2213725 defendant Kember Alan   590942 590942 Kember, Alan, of Swyndon 6
4545927 2214660 2214660 plaintiff Bound John   590942 590942 Bound, John, of Swyndon 0
4557667 2218332 2218332 defendant Rose William   590942 590942 Rose, William, of Swyndon 0
4567171 2221294 2221294 defendant Dyer John   590942 590942 Dyer, John, of Swyndon 0
4572955 2223080 2223080 plaintiff Bakelere Robert   590942 590942 Bakelere, Robert, of Swyndon 0
4572956 2223080 2223080 defendant Palmere John   590942 590942 Palmere, John, of Swyndon 0
4593221 2229177 2229177 plaintiff Palmer John   590942 590942 Palmer, John, of Swyndon 0
4608972 2233909 2233909 plaintiff Brit John   590942 590942 Brit, John, of Swyndon 0
4608974 2233910 2233910 plaintiff Brit John   590942 590942 Brit, John, of Swyndon 0
4650698 2246220 2246220 defendant Clerke Robert   590942 590942 Clerke, Robert, of Swyndon 3
4651351 2246423 2246423 defendant Serteyn John husbandman 590942 590942 Serteyn, John, of Swyndon, husbandman 0
4654192 2247193 2247193 defendant Coryour alias Catelyn William butcher 590942 590942 Coryour alias Catelyn, William, of Swyndon, butcher 0
4661772 2249522 2249522 plaintiff Everard Thomas   590942 590942 Everard, Thomas, of Swyndon 0
4661773 2249522 2249522 defendant Serteyn John ploughman 590942 590942 Serteyn, John, of Swyndon, ploughman 0
4752701 2281250 2281250 plaintiff Tokkenham John   590942 590942 Tokkenham, John, of Swyndon, vicar 0
4753751 2281547 2281547 defendant Byseley John husbandman 590942 590942 Byseley, John, of Swyndon, husbandman 1
4785760 2291582 2291582 defendant Morley Walter chapman 590942 590942 Morley, Walter, of Swyndon, chapman 0
4810274 2299358 2299358 plaintiff Everardes Thomas   590942 590942 Everardes, Thomas, of Swyndon 0
4811990 2299863 2299863 defendant James Walter chapman 590942 590942 James, Walter, of Swyndon, chapman 0
4811991 2299863 2299863 defendant Marler Isabel   590942 590942 Marler, Isabel, of Swyndon, servant 1
4915022 2331204 2331204 defendant Sturmy Richard husbandman 590942 590942 Sturmy, Richard, of Swyndon, husbandman 0
5099698 2386350 2386350 defendant Wilkys William husbandman 590942 590942 Wilkys, William, of Swyndon, husbandman 0
5099699 2386350 2386350 defendant Stichehale Thomas chapman 590942 590942 Stichehale, Thomas, of Swyndon, chapman 1
5099700 2386350 2386350 defendant Taylour William tailor 590942 590942 Taylour, William, of Swyndon, tailor 2
5099701 2386350 2386350 defendant Couper William husbandman 590942 590942 Couper, William, of Swyndon, husbandman 3
5141259 2398564 2398564 defendant Gibbys John husbandman 590942 590942 Gibbys, John, of Swyndon, husbandman 9
5141260 2398564 2398564 defendant Sticheale Thomas mercer 590942 590942 Sticheale, Thomas, of Swyndon, mercer 10
5141261 2398564 2398564 defendant Wylkyns William husbandman 590942 590942 Wylkyns, William, of Swyndon, husbandman 11
5219032 2421295 2421295 defendant Alchirche Baldwin yeoman 590942 590942 Alchirche, Baldwin, of Swyndon, yeoman 4
5250710 2430331 2430331 defendant Norys Thomas gent 590942 590942 Norys, Thomas, of Swyndon, gent 0
5387780 2471567 2471567 defendant Restrype Thomas butcher 590942 590942 Restrype, Thomas, of Swyndon, butcher 1
5544632 2518429 2518429 defendant Halton John, senior yeoman 590942 590942 Halton, John, senior, of Swyndon, yeoman 1
5544633 2518429 2518429 defendant Halton John, junior yeoman 590942 590942 Halton, John, junior, of Swyndon, yeoman 2
5544634 2518429 2518429 defendant Halton Stephen husbandman 590942 590942 Halton, Stephen, of Swyndon, husbandman 3
5544635 2518429 2518429 defendant Halton Edmund husbandman 590942 590942 Halton, Edmund, of Swyndon, husbandman 4
5572476 2526494 2526494 defendant Stephyns William husbandman 590942 590942 Stephyns, William, of Swyndon, husbandman 0
5584424 2530192 2530192 defendant Clerke William yeoman 590942 590942 Clerke, William, of Swyndon, yeoman 0
5584426 2530193 2530193 defendant Clerke William yeoman 590942 590942 Clerke, William, of Swyndon, yeoman 0
5636516 2555370 2555370 defendant Wylde Joan spinster 590942 590942 Wylde, Joan, of Swyndon, spinster 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);